A few torpedoes could do a lot of damage. And yes, a cruise missile with a 1 ton warhead would do significant damage.
It took 19 torpedoes plus however many bombs to sink the original.
I read in some naval warfare magazine admittedly 20 or more years ago that a single cruise missile could not sink an Iowa class battleship.
Also the Yamato’s armor had problems which they could correct.