That's true at least with today's heavy torpedoes. They detonate under the ship, breaking its spine/keel. That will sink a ship. If a ship is properly buttoned

That's true at least with today's heavy torpedoes. They detonate under the ship, breaking its spine/keel. That will sink a ship. If a ship is properly buttoned up, damage controlmen are squared away, etc. most antishipping missiles will result in a mission kill, but not a quick sinking. Even without active intervention, ships stay up through quite a number of big hits in SINKEXs. However, Mark 48 torpedoes and the like are in a different class, and are generally what are used to bring the festivities to a close. Of course, both torpedos and antishipping missiles can carry nuclear warheads, which rather changes the equation. When a friend worked the Outer Air Battle problem back in the day, a projected worry was a regimental-sized Blackjack raid firing AS-16 diving hypersonic missiles with at least some fitted with 300 kt nuclear warheads (AS-16 was/is the Soviet equivalent to the SRAM). Combine that with missiles from Oscar II submarines and Backfire bombers and you've got a party.