The man in charge of England's flood defences has called for a debate on whether communities at the highest risk should be abandoned.