I do think the Galaxy class will see it's 100 year life, hell we have B-52's that are knocking on 60 years now. lol
A very good real-world example. While starships might undergo much greater strains than aircraft, when you account for the materials improvement, the durability should be ultimately comparable. And what are starships if not aircraft/seacraft analogues?

There's also the funny assumption that every ship in a single class is built the same. Internal arrangement and equipment loadout is going to differ from ship to ship and the designs will be updated as built. If the ejection system is flawed - well that's fixed now, and its implemented in all new-build ships and retrofitted to all old-build ships.
Or are Starfleet's Excelsior-class ships all tooling around with their original (now substandard) equipment?
I think Sternbach, Okuda or Probert could attest that while the Galaxy is meant to withstand extreme scenarios, its not its standard mission envelope. I doubt anyone had shield-penetrating weapons or advanced-as-fuck Iconian technology in mind when they designed her (With regards to security architecture... that virus screwed up the Romulans. Considering their usual paranoid attitude, I'd expect them to be stuffed to their eyebrows in security and firewalls. I doubt sincerely that stronger computer security would have helped against the Iconian... stuff). And nothing is going to survive a full-impulse ramming from a fully-fueled ship.
Very well said, Jitty. I hadn't even thought to mention the specific mission load-out capabilities as such.

Of course, enterprise D, odyssey and yamato were depicted as weak for dramatic reasons. But this depiction, unlike behind the scenes minutiae, is part of canon, and has to be considered valid - the trekverse is an fictional universe, after all.
I do agree.
Again, agreed, but I take that with a grain of salt because I know the "real" reason it was depicted as faulty.In TNG, the heroes' ship always failed, and its crew always managed to fix the situation despite that. Enterprise D was depicted as being faulty.
We reach.In DS9/Voyager, we have images that can be interpreted differently - due to scarcity of information.
One could theorise that the galaxy class received a major redesign and overhaul, that its performance improved greatly.
One could say that the galaxy class was a failure in the dominion war (based on information from TNG), and we don't know due to lacking screentime.
How one interprets the information is up to the individual star trek fan, in the end.

Except the Narada...And nothing is going to survive a full-impulse ramming from a fully-fueled ship.
Sorry, couldn't resist... :-)
Only because Robau's corpse was aboard!

Sorry, wrong thread.

About "Generations":
In TNG, we always saw the ship fail and the crew saving the day.
That's why I think that enterprise's destruction in "Generations" should be interpreted as failure of enterprise's power grid or shield emitters (at the BOP's first shot) and not as Worf/Geordi making a stupid mistake that even a first year cadet wouldn't make.
See, with that I disagree, because we don't know that it's a power system failure per se. Those first shots might have damaged the ship's equipment without there actually being an inherent failure. Alternatively, the crew possibly didn't think to rotate the shields, which I think is, as you say, less credible because on the series the crew almost always figured out how to save the day. Overall, it just wasn't spelled out. And, of course, again we know the real reason why it was destroyed.