Desirable places to retire like Santa Fe are already getting expensive.
Cheap private healthcare works for small things, but you are paying out of pocket for everything and if something big comes up you might not even be able to access the care you need. Guam might work instead, but they aren’t cheap and are pretty far away from anything.
Sorry, having lived in Mississippi for 4 years, that is not really true. Or I guess it depends on what you mean by "many", because there are many bad cheap places out there (e.g. Gary Indiana, Port Gibson Mississippi, Monroe Louisiana, ...). It also depends on what you mean by upgrade: many people like big city amenities (food and cultural options) and would see moving to the sticks as depressing, just like many would see the opposite (they love the country side, hate big cities).
Internationally, LCOL areas are generally in developing countries, and even a city like Bangkok will get expensive after awhile (though big cities in the west might get more expensive faster). It is still a trade off, many can't make (and many can, good for them).