Yes, it would be a daunting task. Any threat to New Yorkers has a potential to just by being a threat create disaster.
I believe most people think New York would be evacuated in anticipation of any disaster. I don't know if and how possible that is, in large part because most New Yorkers have no cars and would need to rely on methods of mass transportation. About half of the households in NYC have no cars, and within Manhattan about 70% do not have cars. Any attempt to evacuate is going to really tax our the transportation system. Not sure how many people can be evacuated. Leave early.
As much as transportation is an issue, many New Yorkers will have no place to go or no place that is easy for them to get to. So the evacuees may be forced into some very impromptu refugee facilities.
Water is one of the better systems in NYC. If you live in a low enough building, the water is probably going to come in. IN a high rise, the lack of electricity will stop water from being pumped high enough.
Food and recreating a food supply network, heck that could take years. However, I think being able to holdout for a few weeks changes the whole game for anyone. If you make it past the first three weeks, you might be one of very few people around.
Any disaster large enough to threaten a large portion of New Yorkersis also bound to be a threat of some who live near but not in NYC. The metro area has something like 35 Million people.
My supplies would allow DW and myself to bug in for at least a week, and then water becomes an issue. Food will hold out for about a month. I have to think that by then, I would be one of a few New Yorkers or a system would be up and running.
The real decision is when and how to leave.