This reminds me a bit of the 2010s idea that every house would have a 3D printer to make one off repairs. Years later, this still seems far out of reach. If anything, it seems to have been settled that most non-technicals don't want a 3D printer.
Vibe coded apps are great, but unless they're hitting an already open API, they're effectively hermetic. There aren't many useful, high quality APIs out there without a companion app these days.
I encourage you to ask members of your household what apps they use which don't connect with any other apps, sites, or companies. I think we'll find the number is pretty low.
In your mind, what are some apps which don't currently exist which would be solving a bespoke household issue that non-techies will be reaching for vibe coding to solve?
I'd be happy to be proven wrong, but I'm just not convinced the puddle is very deep. It's really hard to compare taking a photo with vibe-coding an app.