Unless there is not something I am seeing, people aren't racing to move to rural New England. Maybe it's retirees, red to blue state migrations, or remote workers. But I haven't seen a ton of evidence of that. People didn't really migrate out here before covid and I don't think enough people have to justify the rise in prices.
Personally I think people that otherwise would be selling are sitting on their homes because of the interest rates and this is causing a strange feedback loop of low turnover causing low supply which in turn causes new buyers to accept the prices (probably with a hope that interest rates will come down and they can re-fi in the years to come). I also think a non-trivial number of houses that on the market due to the owners passing or going into retirement homes are sitting there on the market because prices are so high but the only money the family is out is taxes. Or they are being turned into rental units, since rental prices are out of whack in these areas too.
My point I guess is where I live we haven't seen a big influx of population (probably the opposite) or significant job or wage growth to make sense of the increase in housing prices. I guess at the end of the day people are just stretching themselves further and sending more money to the banks in the form of interest to get into homes that were literally half the price in 2019. Strange times.