Another fun note about Yamato's explosion is that it appears to have been responsible for more plane losses than all of the AA fire during the battle. For a battleship with well over 100 AA guns, that's a pretty damning indictment of their quality.
One of my favorite YT naval historians, Drachinifel, constantly derides the Japanese 25mm AA gun, which was based on a French design. One of his longer podcasts (in the Drydock series) has a segment explaining the technical details of why.