Look at any car-free area and there are very reasonable exceptions to make them function. The important thing is to remove cars as the mandatory way to access locations, and to cease prioritizing cars over more efficient methods of transit. Forcing cars into our cities took a massive amount of changes to our legal and planning system, and huge huge subsidies. Just going back to thinking of cars as one of many ways to get around, rather than as the primary and prioritized method of getting around, would allow for much more efficient systems.
New York City has more than adequate public transportation, except for the private vehicles slowing it down.
SF has adequate public transit, but without all the cars in the way and with higher ridership it would be amazing.