And in any case, there's no reason that public transit needs to be self-funded. We don't expect the same of most of our other public services.
This is demonstrating my point about population density and transit.
There are many urban areas in the US with population density of 3,000/km2 or higher that do not have any public transit at all.
The US does not have many metro areas with population densities above 3,000/km2. And those that do, like Washington D.C, NYC, Boston, Chicago, do have metro systems.
American cities low density is a direct result of designing for car infrastructure over all else. And car infrastructure is far more expensive than other transportation, and since increased car infrastructure lowers density, it directly makes all other transportation more expensive and less viable.
Since cars are the most dangerous form of transport, for other drives but more so for cycles and pedestrians, it makes it less feasible to use them for your first-last mile. Then you add in that, as the roads grow and distances multiply, speeds are increased to attempt to compensate, multiplying the danger to anyone not in a car.
Public infrastructure has high overhead costs, and low population density means there isn't enough ridership to make it viable.