There is a long history of non-tech users being able to create apps. LLMs are the latest flavor, but there have been no/low-code platforms around since at least the 90s.
Small apps used by a few people tend to work just fine, don't need much help, and become useful little tools. Apps that scale beyond that tend to either crash, burn, and get shut down... or they find professionals who take over the app, refactor the warts, fix it up, and maintain the app on an ongoing basis. It all depends on whether the app is bringing in enough revenue or other business value to be able to afford such professional support.
I see no reason to believe that vibe coded apps will follow a different pattern.