Considering the Yamato had no aerial cover whatsoever and still took that much ordnance... with a decent CAP the Yamato probably wouldn't be so easy to sink.
At least, It's hard to imagine any other naval ship - be it German, US, Japanese, or the Royal Navy - would take so many hits and still survive as long as the Yamato did.