The point is usually to sell a big house in a desirable location, buy a modest house in a less posh an tax-lighter location, and invest the difference to have a steady stream of income.

You usually only need one house to have in retirement, just like you likely won't need a whole /22 in retirement.