> Falklands war shows otherwise.

Well, actually, the Argentinians had no trouble delivering high explosives to UK vessels, but they did have a great deal of trouble getting those explosives to sink those vessels ... mostly because their bomb fuzes were incorrectly set or inappropriate for the delivery profile.

But on a more serious note, none of the ships sunk by air attack in the Falklands were large military vessels. The largest vessel sunk was the Atlantic Conveyor, and that was (1) a civilian cargo ship built to civilian levels of durability, and (2) it was carrying a large quantity of ammunition essentially unprotected (unlike how a large warship would carry it). Even then, the missile strike and fire did not sink the ship immediately. For the largest military vessels sunk by air attack, the two Type 42s Sheffield and Coventry were relatively small destroyers (less than half the displacement of either their USN contemporaries the Spruance/Kidd or a modern Arleigh Burke) and again there the Exocet strike and resulting fire did not sink Sheffield immediately either. The smaller Type 21 frigates lost, Antelope and Ardent, were never really meant to survive meaningful damage and yet both remained afloat overnight before sinking. For comparison, the roughly contemporary USN frigates, the Perry-class (larger in displacement than the Type 42s), survived both Exocet (Stark) and mine (Samuel B. Roberts) strikes.

(The General Belgrano was a larger military vessel lost to submarine attack with, but considering that it was a treaty-limited 44-year-old light cruiser operating unprepared for submarine attack, it is hard to draw too many conclusions about modern ship durability from its loss - and her sisters in the Brooklyn class generally survived quite a punishment in WWII.)

How so?

The ships sunk in the Falklands War were all less than half the displacement of a typical US Navy destroyer. The sole exception is the Belgrano, which was built in the 1930s!

The ship being tested here is ~25x the size of the largest British ship that was sunk. Generally speaking, there is a super-linear relationship between ship size and the amount of explosive required to sink it. There is mountains of empirical data on this that you are choosing to ignore.

Every military knows this. They are making a tradeoff between size, which makes the target more difficult to destroy and easier to defend, and the number of ships they can build which allows them more flexibility in force projection.

Burning aluminum.