To make a long story short - even a successful strike with missile with the nuclear warhead is not guaranteed to sink an aircraft carrier.
It *will* mission kill it (render it unable to perform its mission), which is just as good for most purposes.