This... doesn't seem quite that unrealistic compared to how states act in the real world!
[1] France wanted revenge since the Franco-Prussian wars, Germany wanted a repeat of the Franco-Prussian wars, Russia wanted revenge since its humiliation in a prior conflict (It was ready to go to war over another crisis in Serbia, but then backed down when it became clear that it would not win), and Austria-Hungary wanted to bring its unruly Balkan subjects under its heel.
Everyone involved was itching for a fight for decades.
[2] The British did not make it clear to the Germans that they would actually enter the war (Which probably would have dissuaded them from starting it.) The Germans gave the Austro-Hungarian empire a free hand in deciding German foreign policy. The Austro-Hungarian empire counted on the Germans bailing them out, and for a repeat of an earlier standoff with Russia. (Without taking into account that Russia, instead of standing alone, as it did in their previous conflict, picked up France and Britain as allies.)
All of this played out in slow motion, over the span of a few weeks, prior to the war beginning in earnest.
World War I, due to the prevalent myth of offense dominance that fueled the mobilization feedback loop that led to the war, is pretty much the exact opposite, so, yeah, it's pretty far off.
But basically the idea is that everyone knew a straight-up fight between major powers would be an ugly grind. But national armies take time to mobilize. So you want to mobilize early and try to win before everyone else catches up. This means that once it looks like things might kick off, everyone immediately goes all in. But if your sucker punch fails, buckle up for WWI.
Additionally the ability to stack units, while having problems of it own, made it a lot easier for the computer players to pose any serious tactical threat (without a gigantic technological advantage, a careful artillery and melee formation with a few healing units thrown in can destroy any computer-managed army of even ridiculous size; and the various "cheat" modifiers can magnify that to the point that independent city-states have been observed kicking the tar out of computer-player empires in both civ5 and 6 due to the regenerating free era-appropriate units that the tactical code simply can't out-maneuver)
Multiplayer in 4 tended to be all early rushes and road-ing/choke-ing (get some early unique units or archers to sit on key resources, stealing workers to build roads in between so your units could mass up to take cities faster). Back in the day I had a friend to play intentionally long games over weekends cooped up in the winter, those were immensely fun with a gentleperson's agreement to avoid direct conflict and try to win via tech/culture with maneuvering by proxy. The Civ4 AI personalities were much better suited to this as well.
Never tried MP in 6 but did some co-op in 5 that was reasonably fun, you really had to dedicate multiple evenings to it though so getting more than 3 people was impossible unless you were all sharing a dorm or something.
Overall the most fun multiplayer experience in a Civ-like game I've found was in Age of Wonders 3 as the games had a flatter tech ramp, tactical combat modes that took advantage of the hex map like war-games, and a RPG-light cast of semi-random hero generals to level up and give cute magic items to. Plus it had a variety of MP game modes for both competitive and co-op play.