A small missile might damage or disable a ship but not sink it.
Crass Spektakel

I’d guess because static targets are the only thing it could hit, and air attacks are fine for that.

If the torpedo is traveling thousands of miles at ship speed, that means its target can also move a similar distance. Even if you could somehow get near the target — by dead reckoning and luck or constantly updated guidance — it would be very hard for the torpedo to tell its target from all the other ships in the sea when it got there.

One clap, two clap, three clap, forty?

By clapping more or less, you can signal to us which stories really stand out.