Submarine launched torpedo is and will remain the most lethal arsenal of PN sub fleet.
Heavy torpedo can break the ship into two, sinking is inevitable. Destroyer size ships can take hits from anti-ship missiles and still afloat or remain in fight. Plus ships have more number of mechanisms to defeat the incoming missile for obvious reasons as its above the sea. (Electronic warfare, CIWS, long range missiles, short range missiles, chaffs / flares ....) In contrast defeating a torpedo is more difficult. Modern torpedoes have the capability to distinguish between a decoy and the ship.
An incoming torpedo is a nightmare for any ship. Single hit from the torpedo is a death sentence.