AFAICT, the majority (60%) of funding for roads doesn't come from direct user charges...
Roads are subsidized, free parking (and generally a lot of paid parking) is subsidized, and the sprawl encouraged by car dependence combined with the resulting infrastructure costs has and will continue to bankrupt cities.
I don't think we should "just only have trains", but the current US transit landscape is absurdly stupid and inefficient.
Yeah I think the single biggest red flag that the US absolutely could support more public transit is the fact that many cities successfully had more public transit in the past.