Personally, I think drunk driving isn't that much of a factor: drinking is a relatively short term kind of planned activity. What I think has a much bigger impact is long term stuff, like the desire to live downtown and/or housing prices (with downtown condos and midtown townhouses being more affordable than big detached homes in burbs)

I know families that are rather against the idea of owning a car and arrange housing around that consideration. They prefer to rely more heavily on public transit and the occasional car rental or cab/rideshare.

I wouldn't say that, no. Other factors might reduce car ownership, of course, but I meant only to address the larger question of Uber's potential market. Another major use case is the airport, because airport parking has become egregiously expensive and cost-cutting favors rideshare infrastructure over parking (which is a good thing land-use-wise). There's also "transit in taxi out" trips because it's cold at night and people are tired and don't want to walk/wait/transfer, which grow as public transit is expanded, another trend that is likely to continue because the reduction in air pollution from electrification makes urban areas more desirable, as well as various secular trends pointing towards urbanization that may or may not continue (some recently reversed by the covid-19 pandemic) -- environmentalism in particular seems like it won't go away.

In any case, plenty of people are enthusiastic about a world where owning cars is less popular, so it's a common refrain.