I think in comparison to other navies destroyers afloat currently, CSC does look a bit unimpressive. That is due to a difference in roles of the nations in question however, they still do share the designation. If Canada is justifying the designation as bring a carry over and continuation from the Iroquois class, I think that is a reasonable enough explanation even if it would make some unhappy.
Sure, but who cares really? There isn't a NATO designation for 'multirole combatant' and the naming conventions date back to the age of sail. They no longer really apply for modern ships so it's all just legacy conventions anwyay.
Some frigates will be better at a historical destroyer role than the CSC, but then again, so would a big swarm of small fast attack boats or jet skis.
CSC will do a bunch of things well, but not any one thing well enough to operate on it's own against a second tier Navy, or in littoral combat against people willing to eat a lot of casualties to take you out. With the VLS you could set up a few variants but even if we don't, with the AEGIS it will feed back to the USN so it's less about doing things on your own and being useful to the collective in a full spectrum war.
For patrols or being part of a TG, it will still bring a lot to the table, so pirates would be screwed, could do some useful support to ground troops, and general area denial are all useful things. And if you knew where other ships are, a few Harpoon missiles will still ruin their day. Those are threats though that ships are actually designed to defend against though, so the hard things will be against new threats like the drones, which would require new approaches.
Realized this is all veering way off topic, but the same people that love tradition may just need to pipe down on the class designation if they want to have the 'Tribal' names come up again. Probably an easy distraction though, if you just wave some black and white photos in their faces with the announcement and talk about going back to the WW2 ships that are the namesakes, as well as the battle honours the 280s were awarded.