That is not the valid question. We know from other cities around the world that when transit is good many people will choose to use it.
However your question is phased in such a way as to kill hope: most people don't have the imagination to think of what great transit even is, much less how it would change their life or if they want it.
Most of the costs of a car are fixed costs: your car payment, insurance, and taxes are the same on the car if you buy it and leave it sitting in your driveway all year, or if you drive it 70,000 miles in a year. Thus once you have the car you may as well drive all the way into work and not have to deal with the local transit system. (Unless traffic is really bad or parking is expensive this is the smart thing vs a park and ride). Work is another problem with your statement - if you still need the car to do your normal shopping, get to Church on Sunday, your volleyball club games at night, or whatever else you do with your life outside of work - then the incremental cost of driving to work is trivial so you may as well (again unless traffic or parking is an issue).
The real question is can we as a society afford cars? Cars costs thousands of lives in accidents every year. Cars need a lot of space: more and more expensive lanes on are roads, and many parking lots. A great transit system would save most people a lot of money, and a lot of lives.