I’m unconvinced. When I worked in the field, they were persistent rumours that modern submarines did sink aircraft carriers in actual exercises which I’m ready to believe. A diesel submarine with its motor shut-off resting on the bottom is near impossible to detect.
Not entirely comparable but see how Ukraine seemingly easily neutralised the Russian Black Sea fleet. Modern Navy are not really built for symmetrical conflicts. My personal belief is that progress in space tracking, missiles, subsea warfare and autonomous weapons have made surface ships mostly obsolete.
They have their use but open war is a modern enemy is not one of them anymore.