You could probably build a hell of a public transportation network if people were willing to pay what they currently spend on average on automobile-related expenses (or even a substantial fraction of it) towards a shared network, but people have been making that argument to the American public for the better part of a century now and it's not gained a lot of traction.
I'm not sure that self driving vehicles really change the underlying political calculus that makes Americans unwilling to pay for that sort of public infrastructure. But they could still be an improvement, in safety and resource consumption, vs the current status quo.
Even when State or local governments have funds available, they opt not to build out other options. I think the USDOT offered many billions to states like Ohio to build out rail connections, but they didn't want the funds. To add to that, the states and local governments know about things like induced demand, but they just keep building out these giant highways any way. They could have taken the funds and poured it into public transportation. There isn't much politics cost to it. Traffic is always bad, and people are going to be angry before, during and even after construction because it never solves the traffic problem.
It makes me so sad and drives me crazy that we're doing this to ourselves.