I went to that grocery store twice yesterday (picked up a bag of popcorn and a bottle of water to go to the movies, then later some potatoes and sour cream for dinner). I'm going in a few minutes to get eggs for lunch. So three times in the last 24 hours :-)
You're not wrong, but millions (literally) of people do afford to live in NYC. I live in Harlem, which is more fun and more affordable than many areas.
I'm from Harlem, and other parts of NYC. I moved out to pursue a career in an industry that is relatively non-existent in the NYC metro area. If I moved back now I could probably afford it on my current salary. But there are no jobs there for what I do. And if there was a bigger tech industry in NYC the costs would likely be even higher.
It means my fridge can be smaller because I don't need to keep as much in there. It means it is really easy to shop whatever is on sale - I have two grocery stores near me. I rarely have vegetables that go bad because I can just buy the stuff I need. I can just stop on the way home from work if I'm working the day shift.
I did this for a while when I lived in the states, too, in a small town. I had a similar experience, but it was far less convenient and really only doable because I was in such a small town and lived alone.
If your events are regular, then you don't need to do the research each time either; and it becomes maybe an extra five or ten minutes.
Living without a car is easily possible, lots of parts of europe do it. They do it by living in small aparments, consuming less with more staples
I'm in Norway. Vehicles are expensive, children (regardless of age) are used to going outside and going to the stores. It is a common situation in larger cities. Heck, elementary children are often enough at the store unsupervised. I'm not sure why you think a 20-30 minute car ride plus at least an hour at the store is worse than a 20 minute round trip to the store with a 10-15 minute store break is bad, even if it is a few times a week. And even that can be avoided by just spending a little time on your way home from work.