I'm not sure that's the correct solution here. Giving people flood insurance when they build on the beach in Florida is just a bad idea. There is going to be a flood claim; it's not really insuring against a risk, you know the risk is going to happen several times while they own the house.
Pretty sure the actual solution is earlier in the article. Update the flood maps to reflect the current risk. Sure, people might not be able to afford a property (from the extra insurance requirement) in a flood zone; but from what I can see in the article, people can't afford to rebuilt after Helene so all they did was move the affordability issue from when they bought the house to when Helene hit.