The real trick is to get past the missile defense. CWIS is not a reliable missile stopper anyways, if you can fire enough weapons to overwhelm the missiles you might as well overwhelm the CWIS by firing a few more.

So to be effective you need to dive in the water outside the effective intercept radius of the SAMs. That is a long swim.

What I think would be a real scary antiship weapon is basically air deployable semisubmersible robots. Once you have the enemy fleet located, you map out a “kill box” slightly larger than the range of enemy SAMS. Your bombers rapidly encircle the box, drop the robots and and point them toward the center of the box. Each robot then zig-zag into the perimeter scanning with radar at snorkel. When it sees something it fires a torpedo at it and radio back the contact.