BMD seems to mean many things to many different people.
If the RCN is planning on SM-6 or even the latest SM-2 then there is some BMD capability. That isn't surprising, you would hope that the latest US air defence missile could take down a scud or similar following a dumb, obvious ballistic missile path. Heck you could even argue that Phalanx can defend you against ballistic threats like mortars, shells and some low cost rockets.
That is quite different to having SM-3 and a networked aegis fleet intercepting a space based threat or mid course BM, and that is different again to have a multi-layered land and sea and spaced based system, utilising a range of missiles to provide a defence against ICBMs and significantly reducing the effectiveness of a sides nuclear MAD capability.
Obviously that is a bit more sensitive, and the Europeans generally worry about upsetting the Russians. But that changed I think after Russia's actions in 2015.. NATO then had a plan for BMD.
German Navy to Modernize its F124 Sachsen-class Frigates with New Radar to Join NATO BMD .a The German Navy (Marine) an
www.navyrecognition.com
SM-6 BMD isn't that amazing, its terminal defence, and would be a last ditched effort suitable for something like a fleet in blue water operations. Its very good for an anti-air missile, but its not going to take out mid-course ICBM's, or even terminally intercept nuclear hypersonic MIRV from a nuclear strike unless its coming right for the ship and even then... It won't be taking out those in boosting phase unless the Canadian ship is located ~10 km off shore from Russia/North Korea...
The Germans and the Spanish (and the Dutch) are meant to upgrade their ships to become BMD compatible. But I am not sure where that project currently sits. It seems the Spanish are preparing to adopt newer flavours of aegis and retrofit that into their ships. The French and the UK also have some BMD capability in some of their missiles, but integration seems a long way off, so other than tactical defence of a fleet unit, it still seems a long way off.
Canada with Aegis (CMS330 +) and SM-6 could certainly contribute to a NATO BMD capability, its baked into those systems. Either sharing sensor data, or offering SM-6 missile fires.