I am not an extremely technologically inclined person, and am one of these weird Millennials (I guess) that enjoys driving a car, particularly on road trips.
But I am convinced that in the not too distant future people will look back on the era that we live in and say "That was insane that people got killed driving to work or driving to the store in car wrecks. I can't believe people accepted that as an unfortunate possibility in life." They'll look back on our time just like we look back at 150 years ago and are amazed that people died from a broken arm (not routinely, but it was certainly more of a possibility then than it is today).
In time, they'll get the technology figured out, it'll be a lot safer than humans driving cars, and it'll be accepted by the market because younger generations aren't as infatuated with their cars as older ones are. In fact, many of them don't even like driving and will wait until they are 19-20 years old to get a drivers' license. "Car culture" is dying.