As someone without a drivers license or a car, automation would still be wildly useful in driving down the cost of occasional journeys to locations inconvenient to serve with public transport to a point where it makes living without a car an option for more people.

You're right, though, that the challenge is that it also makes it easier for everyone to opt for cars over mass transit.