When a single ship can shrug off any inbound anti-ship missile, evade detection from enemy ships and aircraft, and yet send the most lethal combination of firepower against enemy ships even seen, I think that means something.
I am surprised they still called it a "destroyer", when in fact it will perform more like a cruiser/frigate. It is no escort ship and it certainly isn't going to be chasing corvettes and other small ships around regional waters as "destroyers" were intended to do. It will be interesting to see how it is deployed, meaning if it is like the Royal Navy and the US sends it out on its own, or will it a part of a carrier group. Time will tell. I'm just glad it is on our side.
Modern frigates are smaller than destroyers, and are typically dedicated escort vessels. Indeed, the Navy's now venerable Oliver Hazard Perry class of frigates were primarily intended to be convoy escorts during the Cold War. They had neither the range nor the speed to regularly operate with the carrier groups. The Zumwalt is definitely in the cruiser class, from a size perspective. It will likely be able to operate with carrier groups, but I would expect it to operate independently, as well. There's not much point being stealthy if you're sitting just a few miles from something like a carrier, which has the radar cross-section of a small planetoid. Moreover, it quite obviously capable of taking care of threats above, on, or below the water. The mention of UAVs also means it might be a good choice for supporting special forces, but it appears to be primarily a blue-water combatant. The Navy is building a whole different class of small combat craft for littoral operations, one that is more along the lines of a shallow-water frigate in size and capabilities.