And no, I'm not suggesting lobbing it around the first cruiser. I'm suggesting to approach the cruiser from a different angle, finding another ship of the CSG and build a perimeter, and then strike the center.
This is not a repeated air assault of the CSG. That's an old doctrine. The doctrine is to completely bypass the defences of the CSG using a hypersonic missile.
And no, you don't do this while the CSG is already in range, that's ridiculous. You do this when it's ~2000km away.
The AEGIS Cruiser's tomahawk missiles have 2500km range.
You're not even outranging the escort ships, let alone the carrier at 2000km. That's why two AEGIS Cruisers escort a carrier.
--------
BTW: This magic drone that can escape detection yet provide enough intelligence to pinpoint ships so that missiles can strike their targets on the high-seas sounds a lot like an F35.
And no, the drone we're talking about is nowhere near an F-35. Examples of such drones are the CASC CH-7, the Okhotnik S-70, the GJ-11, the RQ-170 or the XQ-58. Unlike an F-35 these are extremely cheap, unmanned, and have very long loiter times, meaning that they can cover hundreds of kilometers in radius or even more.
Repeated air assaults to repeatedly tear down defenses (ex: target the Cruiser first, removing the first shield of the Carrier. Then target the next cruiser. Then finally work your way to the carrier) is certainly a workable plan. But again, this is a repeated air-assault against a CSG.
My point is that its not going to take "one missile". Its going to take a campaign, at least if the CSG is doing its formation correctly. In the meantime, the CSG is presumably in range of its target, and also launching an all-out aerial assault.