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.
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.
And yes, a small modern drone can penetrate the scanning area of an E2 Hawkeye. It turns out stealth is a lot easier when your platform is much smaller, and you only care about the frontal aspect. Even moreso when you don't have large-wavelength radar.