Andy makes a very strong and valid point...no ship, even the mighty Iowas, could have survived the concentrated aerial attacks that the US brought to the Yamatos. The loss of these ships was truly the end of the era of the battleship, because it was realized that although these ships (and all the others as well) could not survive concentrated aerial attacks.
When you look at the world's battleships...here's something to ponder. This list is just off the top of my head, so I may have missed a few...I decided to add Scharnhorst and Gneisenau to the list since they could be considered small battleships (at 32,000 tons).
Prince of Wales - sunk by aircraft
Repulse - sunk by aircraft
Yamato - sunk by aircraft
Musashi - sunk by aircraft
Tirpitz - sunk by aircraft
Bismarck - wounded by aircraft, subseqently sunk as a result.
Arizona - sunk by aircraft
California - sunk by aircraft (raised and returned to service)
Oklahoma - sunk by aircraft
Tennessee - sunk by aircraft (raised and returned to service)
West Virginia - sunk by aircraft (raised and returned to service)
Hiei - sunk by aircraft
Haruna - sunk by aircraft
Ise - sunk by aircraft
Hyuga - run aground after being attacked by aircraft
Littorio - sunk by aircraft (still on the bottom in 1943 when Italy left the war)
Conte Di Cavour - sunk by aircraft (raised and returned to service)
Caio Duilio - sunk by aircraft (raised and returned to service)
Roma - sunk by aircraft dropped Fritz X bomb
Gneisenau - bombed by aircraft after hitting a mine, scuttled as a result.
Now we look at battleships sunk by submarines
HMS Barham - sunk by U-331
HMS Royal Oak - sunk by U-47
IJN Kongo - sunk by USS Sealion
And finally, battleships sunk by direct gunnery contact
HMS Hood
Bismarck
Scharnhorst
Yamashiro
Kirishima
It's pretty obvious when you look at the losses, that the era of the battleship was over. It is fortunate for the Allies that the Japanese and Germans were incapable of launching several hundred aircraft in a strike against shipping, as the US fleet was capable of doing by 1944.
So...did I forget any other ships??