I haven't voted in part because of several ships
The Enterprise C was utterly destroyed in battle. Since someone pointed out that the original Defiant was destroyed and no one said no to that, What about the C?
Then there is the first 1701-A in ST-III where the ship was taken over by Klingons and then blown up by kirk. Does that meet the criteria?
Last is the destruction of ENT-D. I forgot the movie. Everyone had enough time to get to the saucer to separate. Given the cercumstances the D had to go thru, I would think it would satisfy the criteria.
I know the Ent-C isn't a hero ship, just as the Ent-B isn't a hero ship even though the latter appeared in a movie helmed Captain Sulu.