No.
The Yamato was destroyed by technology so far advanced that it made starships comparable to sticks and stones in their effectiveness against it. The Enterprise-J would have fared no better.
The Odyssey held its own without shields before an until-then unknown superior force, regardless of it's physical size, sacrificed itself to destroy it.
The Enterprise was lost not because of its specs but a cheat going around them.
All three were lost because they needed to be for story's sake. Nothing would have happened any different if it were an Sovereign, Defiant, Intrepid, Akira, or other starship class in their places. God himself transformed a la Optimus Prime into a starship would have fared no better.
None, it's been said, were lost during the Dominion war, and the ones we saw were kicking ass and taking numbers. The Defiant was beaten left and right and destroyed during DS9's run (and replaced with another ship with inferior carpeting...) yet is it a failure? The Intrepid Class survived encounters with Borg battleships yet have we seen more than one or two others in the fleet? Exactly how many more Mirandas are there than beings in the known universe, and how many do we have to vaporize before we see the last of them?
Botox, Emo, Sovereign.
We don't know how many of the other ship classes were lost over the years. The fan favorite Akira could have the worst record in the fleet. Do you know how many Nova's were lost studying pre-warp cultures? Have a seat, girlfriend, we gotta talk.
They could have blown up the E-D every week for 200 episodes and a single line of dialogue would make it superior to a fleet of Dominion battleships. If the story demands it, a travel pod could outmatch a Borg dysonsphere.
It's a TV show.