Tropical Storm Irene unleashed furious wind and rain on New York on Sunday and sent seawater surging