what are you doing to get into the negatives? I see some people reporting that but haven't reproduced it yet
Level 4 flood is survivable assuming all of your main buildings for food + water production are on level 5 as well as a couple houses. At that point you don't need the resource econ and can just stockpile for the final flood (level 5) which lasts for a bit before the game ends