Tirpitz did get used a few times, but it was mostly useful as a way to tie up a big chunk of the Royal Navy. Eventually, Tirpitz was sunk by aircraft.

The US's four Iowa-class battleships were quite useful, mostly for shore bombardment. They required a huge crew, 2,700 for WWII, Korea), and, after some modernization, 1,800 in the 1980s and 1990s. It's the crew size that led to their retirement. Each turret needed 90-110 people.

There was naval interest in building some "bombardment ships" intended for shore bombardment of countries that didn't have a significant capability for shooting back. But that went nowhere, since most of the US's enemies in recent decades have been too far inland.