In the second quarter of 2022, Canada's housing market saw the 'worst deterioration' of affordability in 41 years, a new report from National Bank Financial Markets has found.