According to my experience, this mission begs for plunging fire solution. But I am not talking about v74, I finished it earlier, so things might have changed.
To go bow in and destroy them quickly from shorter range is possible, but not likely. Reason A - destroyers. Their torpedo spreads are deadly. Reason B - zombification. You damage a ship, she starts to run away and you keep on hitting her already destroyed stern. And then you run out of ammo. Also your ship may had been damaged too so you can be even slower than the escaping enemy.
But imagine this: you stay at around 30km and I presume your ship is armed with 17 or 18 inch guns, not less. With top technology, what accuracy do you have? 5-8%? Thats enough. Load HE (Lydite is not necessary, I was using some kind of TNT). You will pen decks no problem and doing a lot of damage. And they start to run away. But you stay at distance and continue hitting them from above. So no zombification from hitting them to the same spot over and over again. And DDs? When I was playing this mission, they always stayed with their capital ships, they never engaged me if I stayed so far away.
There is a question of them firing back and doing plunging fire damage to you as well. But as I recall correctly, the four original ships were never armed with guns larger than 16 inch. So at distance, the accuracy difference between your 18 and their 16 can be substantial. The Super Yamato is armed with 17 or 18 inchers, you must deal with it.
One more thing: Ammo count. I have a number of unsuccessful attempts with as small superbattleship as possible - with only three turrets. Which gives you around 800 shells. The results were always close and the same. All enemy ships heavilly damaged, all in range, just waiting for the the final blow to be delivered. And then I ran out of ammo. Always go with 4 turrets (double or tripple doesn't matter).