I don't know why you think home prices will go down if interest rates go up. they might not. especially in cities where everyone wants to go and where offer is low.
My hypothesis is that if there is a shortage of housing, then dual income households will bid the price up and this causes the appearance of unaffordable housing when the underlying cause is that there is a shortage. This effect does not happen when there is a housing surplus.