A massive hurricane hitting at high tide isn't that likely at all, but possible. The Sound offers some protection over the open ocean, but very low lying areas are definitely at risk if it happens.