Really, the advent of military aviation made them more or less obsolete in WWII.
There were almost no ship-to-ship battles involving battleships in WWII; they were used almost exclusively to shell inland targets close to shorelines, but there are much more efficient ways to do that and those ways aren't limited to striking targets within gun range of the shoreline.
So it's pretty much carriers and destroyers as far as combat ships on the surface these days. (Not sure the term "destroyer" is used much these days, but the non-carrier surface combat ships are roughly comparable in size to what would have been called a destroyer in the old days)
And then of course you have the many amphibious assault ships, support ships, etc.
