Popular migration destinations, such as Tampa Bay, where home prices soared during the pandemic, could see a housing downturn if a recession happens.