Technical measures, insurance, all fine. But the most important factor was named by Wiltshire. Which type are you or are you all?
I have a colleague who sat next to me when the flood was already flowing down his street, sandbag barriers were being built, and he said to me when I asked if he didn’t want to drive home, "I’ll manage here somehow on my own... What am I supposed to do? Scoop away the floodwater with a bucket? Stand in front of the dam with tears in my eyes? In the worst case, you just have to renovate..." If you are that type, build there.
If you are the type who already gets a stomach ache when the warning card shows level 2 or 3 for heavy rain, then don’t do it. Also think of your better half. We had water standing up to the bottom edge of the slab on the property in the year when Lower Saxony and Saxony-Anhalt sank in floodwater. I was relaxed, the slab is waterproof, no danger... for my better half a world collapsed that day... if there had been a real flood danger for us, we would probably be living somewhere else by now...
Technical measures are expensive, insurance only steps in after the disaster has already happened. The personal component is decisive. It’s no use to you if the insurance pays for the renovation but your family no longer wants to live there and leaves you sitting there alone.