We don't really know what kills starships in general. Kirk's ship was never really threatened by conventional destruction, save for "That Which Survives" where something very much akin to a warp core breach was fast approaching until Scotty saved the day. The ship was threatened by other, more interesting fates, such as being miniaturized, crushed by divine hand, erased from history, or sucked into a planet in the throes of temporal weirdness.
Janeway's ship was seldom destroyed, and it took nothing less than a year of hell to achieve that much. Sisko's ship was destroyed by a superweapon. Archer's ship wasn't destroyed. With that little evidence, it's quite difficult to assess whether certain types of starship might have weaknesses or flaws.