It was the "Ship of teh Sisko". What more can you ask for? Hopefully that's coming, at least in episode 10.
Arguably the Defiant was the most prominent ship, despite being...very smol (sorry Worf) in many Dominion War engagements. The E-A, Bounty, Q-1, Excelsior and NX-01 arguably are the most logical additions there. Stargazer..sure..Picards ship, ship of the "Picard Maneuver"..but otherwise just a normal Constellation Class starship.
That'll probably piss off a lot of visiting Ferengi - glorifying the ship captained by the Butcher of the Battle of Maxia!
We can't limit our imagination on these things to simply what we've seen on TV and in movies. It's a great big Federation and no doubt there were other ships and crews that did historic things. Sure, some of them are more or less random (USS New Jersey NCC-1975 is someone's birth state & year). At least they filled out the part of the museum we've seen so far, quite nicely in fact.
So it would seem. The fan-fiction that TM liked was that it had been on an extremely long range patrol and when it returned it ended up staying in an un-modernized state, eventually going to the Academy as a training ship and then ending up at the museum
I think the difference is that the Enterprise-A = Rechristened Yorktown wasn't explicitly stated in any on screen material. But it is worth noting that it's said that rechristening a ship to a new name is bad luck.. And it cannot be said the Enterprise-A didn't run into a massive ration of bad luck from Day 1 until TUC.
I think being three ship that broke through the lines and delivered Odo to accept the female changeling's surrender would make a pretty famous ship.
Gonna say something controversial... I don't think the Defiant should be in the fleet museum. To glorify a warship, just doesn't seem very "Federation". I love the ship and it of course deserves mention in history books, but to put a warship on a pedestal, to me, kinda goes against what the Federation stands for. It should almost be thought tragic that Starfleet had to resort to making a dedicated warship. But that's me.
Museums are examples of historical events and their significance. Doesn't automatically convey glory.
Fair enough. I guess it could also be that the Federation of the late 24th/early 25th cenutry isn't so gun-shy about warships. Between the Defiant, the Prometheus, and the Inquiry class starships, Starfleet has definitely taken a step back from the moral high ground of "no warships."
I mean, they suffered intense losses. It would be even more bass ackwards and crazy to not recall it and not learn something from it.
That makes me wonder, did the Dominion War cause even more culture shock then the Romulan War? I mean, I'm sure the number of deaths were far greater during the Dominion War, but that was because it was pretty much the "World War Alpha Quadrant." But on the more personal level of Earth vs. Romulus, it had to cause one hell of a panic on Earth, especially after the whole "Xindi thing." Didn't DS9 mention that Earth itself was attacked during the Rom War? So we know it must have got pretty dicey. But Earth/The Federation managed to come through it without becoming all "hawkish". They were still all about exploring. Star Trek Beyond even kinda hinted that the more, we'll say right leaning, hardened veterans of the war felt somewhat ostracized in the early days of the Federation..... God I want a Romulan War series/movie/mini series.
Sisko(paraphrasing): "A war against these Changelings would be the kind of war that Earth hasn't seen since before the founding of the Federation!" Now that line could mean World War III. It could mean the Earth-Romulan War. But I prefer to think the latter. The writers of DS9 knew that Earth and the Romulans fought a bloody war before the Federation even existed.
I think it did not because of the casualties but because of the nature of the foe. To quote SF Debris "The Borg might turn your friends against you; the Dominion they might already have." The Federation, and Earth, are built around mutual trust and cooperation. Every facet, even computer security, is treated as a matter of trust. But now, you have a foe who could be your friend. It damages a society to be that paranoid. Also, similarly, you have a use of ground troops on a scale the Federation hadn't faced in a while. I think all of this takes a toll.