There is no shortage of human intelligence in the world. The average person is remarkably intelligent. But they need a lot of learning and practice, and often plenty of organizational support, before they can use that intelligence to do something useful reliably.
We know how to make cars that are stupid and reliable. We know how to make cars that are intelligent and unreliable. But there is still a lot of work to be done before we can make cars that are both intelligent and reliable.
The only AI product I use in my daily work is Copilot. It can usually make useful and accurate suggestions, sometimes even remarkably so, but it also makes stupid mistakes all the time. Copilot is most useful for automating boring routine work, where I can quickly catch and correct its mistakes. It's far less useful for the difficult parts, or when I don't know what I'm doing, because the mistakes it makes are less obvious to me.
https://youtu.be/-Rxvl3INKSg is a news reporter's video of taking a ride in one, so you can see what it's like to ride in one. She's a news reporter and thus not your average person because she has access to Waymo because she's a reporter, but members of the general public are also getting access and are able to do this as well. After watching that, I think a reasonable average person could believe that self driving cars are here.
As was said upthread, the future is here but unevenly distributed.
This one in particular, I find fascinating, because we've literally just _had_ a hype cycle over it (I remember people telling me they'd be here any day now a decade ago), and now we're onto another AI hype cycle, almost immediately. Which comes first, AGI, or the self-driving car? :)
(I think your other examples are qualitatively different; moon bases, supersonic (passenger) jets and asteroid mining are clearly possible, but impractical for economic reasons; no-one is willing to _pay_ for them. Plenty of people are willing to pay for both self-driving cars and AGI, but there is just no clear route to achieving either.)