The large ships are well-protected. A “small unmanned underwater ship” has been a primary threat model for a century e.g. heavy torpedoes. These already have very long range and sophisticated sensors that allow them to hunt targets autonomously.

The other side of this is that modern large military ships are almost literally unsinkable. It is very difficult to get enough explosive on target due to their extreme damage resistance.

When the military does live fire exercises where they attack obsolete military vessels with no active defenses using torpedos, missiles, bombs, etc, they usually don’t manage to sink it. They have to send a specialized demolition crew afterward to actually scuttle the damaged ship and turn it into an artificial reef.

An operational large military vessel will have layers of substantial active defenses that make this even more difficult.