Something that I think is being missed here is that BabelHuber is arguing that the (I'm going to say) heavy cruiser, if not a straight up battleship,
Galaxy-class shouldn't be used as the workhorse "do all the missions" multi-role backstop of Starfleet. And he's more or less right, because...it isn't.
Galaxy-class ships are explicitly the flagship, fuckoff-expensive, tough, omnicompetent, heavily-armed premier ship of the Federation, used in missions of particular importance: transporting diplomatic envoys into potentially dangerous situations (any number, but we'll go with "Code of Honor"); investigating potentially dangerous negative space wedgies, which may involve transporting mission-critical specialists (let's go with my favorite, "TIn Man"); showing the flag in incipient or actual combat zones ("Redemption I/II", among others).
The workhorse of the 2360s Starfleet is not the comparatively rare
Galaxy, it's made up primarily of of
Nebula-,
Miranda-,
Ambassador-, and
Excelsior-class ships. We think of
Galaxy-class as the workhorse because that's our hero ship, but the vast majority of times we see other ships, they're the above-named classes, at least in TNG (and to a large extent DS9 as well). We only see two
Galaxy-class in the entire TNG run:
Enterprise and
Yamato. We see, I think, three more named in DS9:
Venture,
Odyssey, and
Galaxy, and one more named in Voyager, the
Challenger.
Want to try and list all the named cruisers and frigates in the four classes named above? It'll take you a long damn while. The
Ambassador are older versions of the fuckoff battleship by most indications, but the
Miranda and
Excelsior have apparently gone under redesign and refit, and are still under new construction (cf. the fleet from "Redemption II").
It's even pointed out
in-universe of the
Sovereign, the 2370s new model of big badass omnicompetent battleship:
First Contact wrote:Cmdr. William Riker: We finished our first sensor sweep of the neutral zone.
Captain Jean-Luc Picard: Oh, fascinating. Twenty particles of space dust per cubic meter, 52 ultraviolet radiation spikes, and a class-2 comet. Well, this is certainly worthy of our attention.
Cmdr. William Riker: Captain, why are we out here chasing comets?
Clearly, both Riker and Picard are in agreement that the
Sovereign-class
Enterprise is wasted conducting routine stellar cartography.
I will, however, point out that the four smaller classes I named are still, by and large, multi-role.
Defiant-class ships are never the backbone of the fleet in the same way, probably because of their specialization. It's clear that barring emergencies,
Galaxy-class ships aren't sent on routine or podunk missions. We see them only when they get massively complicated or hazardous because, again,
Enterprise is a hero ship. We see the exciting missions.