The housing market is so unaffordable that a record share of homebuyers are looking to relocate to cheaper cities despite rising natural disaster risks