There's an exception for "any residential property found outside of a Census Metropolitan Area or Census Agglomeration as identified in Statistics Canada’s Standard Geographical Classification 2021."

I've not looked at a map to see how much area that covers, but it sounds like foreign buyers could still purchase rural properties.

https://www.cmhc-schl.gc.ca/en/media-newsroom/notices/2022/e...