A single torpedo in the forward or rear magazine will cause Yamato to go up in explosions and flames before sinking like a stone. The trick is to find that spot.
The forward magazine is under the fore turrets. You can find it with a little practice. The rear magazine is harder to hit, for me at least.
Good luck, and welcome to Subsim!