The great part about a severe correction in home prices is that.. Well I think generally speaking... Luxury homes have a higher beta than non-luxury homes, i.e. Luxury homes correct harder than non luxury homes. If you're staying in a 1m home hoping to leg into a 2.5m home, it sometimes happen that a correction drops your home value by 150k and the target 2.5m home by 650k or more. So the hurdle to change home just got cheaper by half a mil... Which is a good thing!
The scenarios you mentioned are the risks of overleveraging and that applies to everything. Few people leverage their retirement portfolios. If your home value is 90% of your retirement, why take that risk? Would you gear 90% of your retirement portfolio 4-5x and put it in a single asset?
But overall, housing prices do increase over time relatively inline with inflation. So even if Vancouver takes a huge hit in the short-term, over the long haul it will keep going up.
One interesting thing I noticed is that some housing markets don't really go down that much, they just stop growing. I can remember the home my parents owned in Toronto. They sold it for $325K in 1990. In 2005 I looked up the price and it was about the same. Adjusted for inflation, the it was a price decrease.
This isn't actually what happened in Toronto, to be clear. There was a huge housing boom (especially condos) in Toronto in the late 80s, followed by a bust. >100% gain in real housing prices between 1985-1989, then a 40% drop between 1989-1996. What you saw was a housing collapse which took until the 2000s to recover, not a flatlining.
The owner is not "saving" $480K, but a sum quite a bit smaller than that, likely around 20-40%.
But long-term, ordinary Canadians living in these properties stand to make out alright (indeed - assuming this is not a long-term depression in prices). They get their utility out of the property (if city rents are 2-3K/mo for a 2 bedroom, that's 480K over 20 years in "cost of renting the space" which they don't end up incurring).
I cannot speak for Vancouver, but scenarios in the US where cities saw non-trivial % declines had those % returned in-kind within a decade. So we're seeing short-term losses, it will impact folks selling today or tomorrow, but not in 10 years (as I've caveat-ed along the way: probably).