To sink it, yes.

To render it useless for a while is easier.

https://en.wikipedia.org/wiki/USS_Enterprise_fire

All from a little drone-sized warhead.