This is an excellent comment, and honestly should be visible higher up. You should make a top-level post out of this!
Maybe their space fleets are all that is left of those specific countries? Maybe they were maintained in service with the vague idea of being a "government in exile" (or "society in exile") before eventually uniting as "United Earth", but purely in space.
Oh that's a really good point about the Holo-Revolt. And it's interesting -- now that you draw attention to it, I don't think we have seen any holograms serving on ships we see on LDS. I wonder if a Holo-Revolt did happen and lead to Starfleet banning holographic officers... with Chakotay and Admiral Janeway managing to lobby for a one-off exception for the Protostar given a) the exceptional circumstances of returning to the Delta Quadrant and b) Janeway's personal desire to never return to the Delta Quadrant but Chakotay insisting that her expertise was indispensable. Holo-Janeway could have been a one-off compromise.
… so, Romulans were running the show.
In theory, we already knew this: Commodore Oh is a Romulan agent, and we are shown that she is in a position of power within Starfleet Security in 2385. In fact, given how quickly the Synth Ban is overturned in-universe, I think Chabon wanted to leave us with the general impression that Romulan/Zhat Vash influence was both pervasive and the driving force behind the Ban; once removed (by way of Oh's exposure), the Federation seems to quickly revert to its "good" "uncompromised" self.
Now, I think that's an overly simplistic depiction of institutional prejudice and societal change, and I think it undercuts the attempts PIC S1 made to question the moral purity of, well, everyone: Picard as a person, Starfleet as an organization, the Federation as a society. The handwave of "...and it was all the Romulans' fault!", in my opinion, lets everyone off too easily.
But I definitely believe that the textual intent was to indicate significant Romulan influence over Federation policy in the 2380s and 90s, and I think the backstory from PRO and LDS creates additional complexity and therefore additional opportunity to weave a more nuanced portrait of Romulan involvement.
appears to ban synthetic lifeforms themselves.
This part, though, has never sat right with me. It deserves a lot more examination than the line or two we got in the season. Right, and that's part of my point. The suspension of research I agree is one thing, and is better justified in the show. But the outright banning of synths is racist and reeks of fascist regimes in a way that, I agree, is completely underexamined in the show.
My point is that we can recontextualize the Synth Ban into something that isn't a reaction to a single event but is rather a reaction to a series of mounting crises. I'm not saying that it puts the Federation in a better light, but to me it makes it more believable.
To draw a potentially provocative comparison: if the Attack on Mars is 9/11, then the Battle of the Living Construct is the Oklahoma City Bombing, and the Battle of the Texas Trio is the 1993 Bombing of the World Trade Center. And I'd argue that those are important pieces of historical context to understand the reaction to 9/11; 9/11 punctuated the emerging narrative from 1990s terrorism that the world Was No Longer Safe.
Setting aside the plausibility questions though, one way or another the franchise has established this series of three AI catastrophes in short order (to say nothing of DSC's Control Crisis, nor PIC S3's use of interlinked starships); whether or not they needed to do this to justify the Synth Ban is, I agree, debatable. But yeah -- intentionally or not, they do seem to have created a more complex backstory here.
I propose that the Enterprise-E became somehow entangled in something it could not be removed from. I have a mental image of the ship somehow stuck in "spatial quicksand" or maybe an infinite timeloop -- some situation where Captain Worf saved the crew and the ship but then was not given the resources needed to extricate the vessel, leaving it to be abandoned in its place.
More heroically, perhaps the Enterprise-E "saved the day" by hooking itself into, say, the mainframe and physical hull of some starbase that suffering from some sort of collapse of software and/or hardware -- saving the station from imminent destruction, but irrevocably welding the ship and station together. Again, perhaps Worf thought he'd be given support from Starfleet to eventually extricate the ship, which would explain why he would later feel justified claiming that the ship's ultimate fate "was not his fault".
This is an excellent analysis. And you are totally right about Chakotay: he is never ever referred to as "Lieutenant Commander". I like your Watsonian explanation! That's a really interesting take.
Of course, this is also the show that was bizarrely inconsistent with Tuvok's rank. Interestingly, between Kes, Neelix, the Doctor, and Seven, I think VGR may have had the most rankless characters of any series up to that point. I suppose DS9 could be tied, since VGR only had three rankless characters at once, as did DS9 (Quark, Odo, Jake).
But yeah -- I wonder if this reflects a larger trend. ENT definitely leaned on simplified ranks as well -- instead of the TNG-era 7-rank scale, we only ever see four on ENT: Captain, Commander, Lieutenant, and Ensign. (It's not clear to me that the costume department even designed a "hollow pip" for the ENT uniforms.) Under that analysis, we see a gradual trend toward de-emphasizing rank, from DS9 to VGR to ENT to DSC to PIC & PRO (though not LDS).