The Cole was literally moored for refueling, not quite at peak readiness, and not really what we're talking about here.

But the whole point of how carrier defenses work is to not wait until they're literally on top of you (like on your example of shooting your own ships). Speed boats are stupid loud on SONAR, so you should detect and destroy them before they can even see the carrier group.