My elderly parents have asked me about "local backups" of their cloud stuff, their Facebook history etc..
If they're thinking about the risks/tradeoffs of being in the cloud..
I think people use the cloud because there's no better/easier option today.
But at some point there might be. A home appliance (which may be similar to a homelab under the hood but the user experience is where things change) that provides a bunch of automation and home services could be quite attractive if it got to a point of being very turnkey for the average family.
Just like a TV or a gaming console is today.