Insurance isn't an endless bucket of money, and it's also going to adapt. Eventually you just won't be able to get insurance for properties in areas like that. Just look at the floods in New Orleans or the current flooding along the east coast of Australia, I doubt there's enough money to make all those affected whole again.
I think insurance may be the main driver for when people actually decide to move. People are pretty resilient, but if you can't get a home loan because you can't get insurance, people won't keep living there.