It really depends on where you are though. Much like other public policy debates, a lot of this comes down to where someone lives. People that live in dense urban areas can very reasonably go without cars, and trains (specifically light rail) make a lot of sense. Once you get out of urban areas, suddenly trains don't make any sense at all, and the ability to realistically take public transportation evaporates.
This is compounded by urban planning that doesn't prioritize dense housing. Everyone says that we need more and better housing, but no one wants high rise apartments and condos in their neighborhood of single-family homes. That ends up leading to the kind of urban sprawl that makes public transportation impossible to work. Until zoning is taken out of local hands--so that wealthy communities can't prevent high-density housing--you aren't ever going to see this kind of thing change. (BTW - this is overwhelmingly happening in the US in communities that have a Democratic supermajority; that's why housing is so expensive in California, because new housing isn't being built.)