Insurance companies are already worried. I expect them to start writing into their policies exclusions about man made climate change. Which most people won't notice until it is time to file a claim. And then there will be a big uproar.
It works poorly for cases where the risks are unknown at the time the insurance is sold and then turn out to be correlated. For example asbestos-related lung disease claims basically wiped out many syndicates at Lloyds (though this was exacerbated by other problems like the accounting practices or underwriters having unlimited personal liability)
There have been some consequences. It's no longer possible to get buildings insurance or mortgages in certain flood prone areas.
This effectively makes them uninhabitable, because uninsured flood damage can easily bankrupt a house owner.
Surely just unmortgageable?
Oddly I think refusing to mortgage homes on flood plains is actually a good call by the banks. The local councils are just building in whatever idiotic places they like, stripping hills of the foliage which absorbs water to put houses there, then putting even more houses below where all the water now has to flow.
In one case I know well the old couple living there used to just chase the flood water out of the house with a running hose to clean it out. They sold the house to a young couple who redecorated the whole house and put carpets and stuffed furnishings on the ground floor. A few years later the whole lot was ruined, they sold and moved out. Apparently their neighbours tried to warn them.