I think that moves the goalposts a little, Christopher. The comparison of the Sovereign being heavily armed isn't just that the class is heavily armed overall, but that she's heavily armed compared to other contemporary ship designs.
Which is exactly the comparison I am making. My whole point is that it would have to be compared against other classes.
For example, in simple torpedo launchers, the Galaxy has one forward and one rear launcher, while the Sovereign circa First Contact had at least 1 quantum torpedo launcher along with 2 large forward launchers on the engineering hull and 2 rearward facing launchers. Then we also get two supposedly in the saucer, which gives us a much larger torpedo arsenal than any contemporary design. Combined with the fact that the ship is armed with a larger number of phaser array strips than comparable 24th century contemporary designs, and that gives us some sense of the ship's RELATIVE capabilities next to comparable ships like all the Galaxy and Nebula class ships we see in the fleet scenes.
But you're talking about the Galaxy class's known armaments during TNG. Is it logical to assume they didn't add more weapons to the Galaxies built for the Dominion fleets?
Look, I'm the first to admit that in real life it was absurd that the Dominion battle fleets were so dominated by Galaxies and older classes rather than the newer, post-Wolf 359 classes like Intrepid and Sovereign. But that's what we're stuck with and we have to formulate our theories based on that evidence. So it seems to me we have to conclude there's some reason why, despite what we'd expect, the Galaxies and Excelsiors and whatnot proved more useful for combat than the Sovvies. Maybe it's similar to the rationale used in the Romulan War duology for building more Daedalus-class ships rather than NX-class: because they were easier and quicker to mass-produce due to the production process being simpler and well-established.
In terms of balancing the evidence, I think that tends to show at least that Starfleet seems to parcel out their most advanced/powerful designs and throw them into independent functioning roles rather than sticking them into fleet actions.
Okay, maybe. But that still works to explain why the E-E wasn't in the front lines, and that's my primary goal.
I still stand by the assertion, though, that the phrase "advanced starship" does not merely mean "powerful warship." Starfleet vessels are something far better than mere warships.
For the most part I agree with you Christopher, but I think you might be trying to argue to many points. The explanation of Picard being better suited playing diplomat and getting allies is perfect. As is that the Sovereign and Intrepid classes are relatively new so not many in service and it might have been cheaper/quicker to mass produce the older models for fleets is a perfect companion.
The extra "so therefore Sovereign isn't a good warship" is a step too far for me. It's 1+2=4. It's jumping a step somewhere. For me, it's not the Borg that they're facing, so Picard is better served getting the Federation allies, as I've already said.