You can take very good images with a good smartphone. You can even edit so that the majority of folks looking at them on a phone, pad, or screen like them. In fact, I know a number of folks who got themselves a proper camera - only to be utterly disappointed by the image quality especially in low light and low contrast settings. Smartphones turn those images into something people like.
I can't predict the future, but it is fun to do. My experience is a bit different.
Younger people, who use their smartphone cams a lot, show a lot of interest, when I'm taking pictures with a "real" camera. I'm good at taking photos and know most of the technical important stuff, but definetely not the most advanced photographer on earth.
When they see my pictures, some of them start to become too shy to take pictures with their phones or show them. Last week, I was showing a collection of pictures from an event on my smartphone, some taken by me, most taken by smartphones - an iPhone 12 by a professional tv-camera man. He is good at taking pictures. When one of my pictures came, a friend of mine immediately said: this isn't from a smartphone, isn't it, it looks too good? And this was a pic taken seconds after the iPhone shot from the same perspective.
It is as it is with music: if you love music and are good at it, you might love your first preset-synths or some loops you put together, but if someone comes along, who uses real stuff, the difference becomes obvious, even if the later is in some aspects less perfect. It is the sound that is real, like "real" pictures have something computational photography can not archieve.
When I was young, I was interested in photography, but I stopped doing it. The cams I could afford weren't good, it was that experience to take 24 pictures in weeks and then you would see the results in small prints weeks after some of the pics were taken and you forgot what you wanted to archieve and how the camera was set up. And you had to pay for films and the development.
Maybe some of the buyers of film cams are posers - saw a young girl in her early 20s with a hasselblad in the park today

- but so are many people, who buy guitars or synths, but not all of them.
What you wrote about people being dissapointed after buying a dedicated camera is my experience, too.
If the manufacturers do their homework, they will prevent this from happening, but at the same time draw the users away from the auto-modes.
Without making a judgement about how good they are at doing it: I like Fujis concept to put all the high-tech stuff available into their cams in transparent menues - but to offer all the traditional controls on the body and even the aperture-ring on the lenses.