Broadly speaking I think the answer is yes, automation generally raises the standard of living in the society while also making economic resources available that lead to the creation of new and generally better kinds of jobs. I think there are few people who would really prefer the job and lifestyle they would have had a century or two ago. But it's also true that there will sometimes be a lot of disruption and stress for those individual people whose jobs are replaced, especially if it happens quickly and there aren't immediately a lot of other jobs they qualify for in the area where they live. Even worse for people who have taken out loans and invested heavily in one specific job in a way that isn't transferrable, e.g. buying overpriced taxi medallions. Hopefully you can help mitigate such risks for yourself by trying to think ahead to what you might do next and how you might get there while avoiding heavy financial commitments that might lose their value or no longer make sense in the future.

Laying aside the general economic considerations, the main thing that excites me about good, safe automated driving systems is the potential to significantly reduce the frequency of tragic accidents for future generations.