An aircraft carrier would be incredibly difficult to actually sink. They could manage a “mission kill”, inflicting lots of casualties while knocking a major ship out of action for many years.
Remember the Argentinians sunk a five billion dollar British destroyer with a $250,000 dollar Exocet missile.