Except that's not what we want the MCDVs to be... If Canada wanted corvettes, we would have bought corvettes. Complaining that the MCDV and AOPS aren't armed like a firgate/destroyer is akin to complaining that a MSVS doesn't have the armour or weapons of a LAV6... Sure they both have wheels and move people, but they are designed for different roles.
99.99% of the role of a navy isn't shooting at enemy ships. Look at the history of navies, and look at the number of battles they have fought. The RCN needs combatants, and the CSC will be world class combatants when they are built, but we also need ships to do the other 99.99% of missions, that don't involve shooting at enemy ships.
EDIT: After a quick google, the RN of 1805-1815 consisted of 950 ships, of which only 113 were "ships of the line" a.k.a. frontline combatants. The RCN of 2040 will consist of ~15 ships of the line, 20 non-combatants, and 4 subs... The RCN by percentage will be more combat capable than the RN of the golden age of Napoleonic Wars.