Given that you bring up the space program in the same post I'll stick with the metaphor and point out that you can't go to the moon by climbing up trees, or as Russ Ackoff said, doing the wrong thing right is worse than doing the right thing wrong, because making the wrong thing more efficient just makes things worse.
If you want fully automated, efficient transport this technology already exists, it's train and subway systems. We even know how to virtually automate them 100% already, 24/7. With the tens of bilions if not more spent on driverless cars you could have actually rebuilt a decent chunk of infrastructure.
Having individual people drive around in two tons of steel to buy a bag of groceries is fundamentally stupid and its destroying cities, whether the car is electric or automated doesn't matter that much and there's no gradual change away from it, only a disruptive one.