Everything is doomed in the long run. Most of those houses look like they could withstand the <=1 meter sea level rise expected by 2100. That is generations of owners enjoying them and making profits. I imagine at some point the home value will start to decrease, but that could be gradual and a long way off.
The "expensive lesson" for the next several "dumb" owners could be that they owned a beautiful house and sold it for millions more than they bought it.