Very interesting topic, this is, thanks for opening up this forum.
As someone said, the future is inevitable. In the long run, this will probably happen. As for the effects on the human spirit, at least for the older generations, it will be sad because cars represented things like freedom, adventure, first sexual experiences, and control of our destinies, amoung many other feelings that come along with driving. Those feelings might not be totally eliminated with autonomous transportation but it will not be the same for us. The younger generations will accept them with greater ease since the world they are growing up in does not give them the same nostalgic feelings we had. It will also give them more time to be on their smart phones anyway.
Assuming that the bulk of these vehicles will be electric, natural gas, or hydrogen powered, it is going to take billions/trillions of investment capital to set it up. Even now, our dated and underfunded elecrtrical grid is teetering. With the buildup of electric cars now that problem will only get worse. Lots of work to do.