> The sinking of the British Prince of Wales and Repulse by the Japanese is probably a better example of how battleships became vulnerable to airpower.
In retrospect the Japanese got a bit lucky there; subsequent air attacks on battleships show they can be remarkably tough. Musashi took 19 torpedo and 17 bomb hits to sink.
But these days you’re defending against the likes of squadrons of low flying B52s firing 20 (possibly nuclear) cruise missiles each. The bombers can fly back and re-arm much more quickly than any fleet, and there are a lot more bombers than ships. Add in submarines, destroyers and other platforms with even more missiles and I doubt any large ship or fleet will last long in any serious conflict.