Addressing the flood risk in Southampton is the “existential challenge” facing the city.