The $100 million initiative only would protect Red Hook from a 10-year flood event, not the 100-years officials had anticipated