I disageee; if self-driving cars eventually work as well as some people expect them to they will become the norm very quickly. Whether or not the technology will be good enough to allow that is, as far as I can tell, still an open question. However, some of the largest and most successful companies on the planet are spending billions of dollars a year to develop self-driving cars, and these corporations are not known for having infinite cash reserves or chasing sci-fi fantasies like flying cars. Also, these car companies have a lot to lose if automobiles ever become a mere appliance. That they are investing so heavily in self-driving vehicles suggests that they see fully-autonomous cars as their best road to long-term profitability.
The potential market for self-driving vehicles is huge. Most people are not auto enthusiasts. They drive because they have no choice. In places where public transit is a realistic option the rate of vehicle ownership drops dramatically. Many of these drive-because-they-have-to drivers are going to embrace self-driving cars as soon as they are convinced the technology is mature enough to keep them safe. The various delivery sectors are going to embrace self-driving vehicles too because they eliminates one of their largest recurring costs: paying human drivers. Then there is the aging population. Most people alive today in the US and Canada have been driving all their lives and are not going to want to give up that mobility as they become unable to drive safely. Aging baby boomers are numerous and a natural market for self-driving vehicles. And these are just the markets that come to mind immediately.