Self-driving cars are going to bring the cost of a trip way down and when the cost of something drops, we tend to use more of it. Rather than a big shared fleet, I suspect people will continue to buy their own cars and will in fact own more of them because (eventually) they will be much less expensive than current vehicles.
People already spend far more on their cars than they really have to and I doubt that will change.
On the plus side, I think the inexpensive cars of the near future will probably be small and electric with a much smaller operational carbon footprint. On the down side, when you have a robot chauffeur, the value of proximity drops and so I think they will fuel sprawl like nothing else before.
I guess I'm saying I have no idea what's going to happen, but I doubt it will fulfill the Polyanna prophesies that I sometimes read about.