You could test the relationship by looking at New Jersey and Connecticut: lots of people are relatively independent from cars for their commutes, but tend to have genuine houses (as opposed to their coworkers who live on the Lower East Side).
I'm guessing you mean the part of CT that's close to NYC. At least when I was growing up in the 70's / 80's, my part of CT had literally no public transportation, except for the occasional bus service for senior citizens.
To me it wouldn't, I live in the middle of no where near my family, I couldn't work for big tech and stay here. But I bet it'd shift a lot of opinions.
That would eliminate about 75% of what I hate about working in an office. Cubes are hell. The only hell worse than that is an open office layout.
... I just don't like it enough to make it worth 5ish hours of fighting rush-hour traffic [edit: per week], right after getting the kids where they need to be (for the morning half, at least), not being able to do my mise for dinner over lunch or move some clothes to the dryer during the day, the gas & wear & tear on my car, the risk to life and limb, not being able to work-and-travel, and not being able to move somewhere far away without changing jobs. Plus I can greet my kids when they get home from school every day.
I don't prefer WFH per se—I prefer working in an office, especially in a nice area with cool stuff around, not so much in some soulless office park—but with that all factored in, it's not even a close call. WFH by a mile.