When a coworker (IT staff, in your case) leaves, they get replaced.
Family just leaves a hole. Maybe some duties get taken over, maybe not. You may leave behind an IT shaped hole, but it's not really a new or unique problem. You lose the person who organized the holidays, the family reunions, the one who made the good pie, the peacemaker who kept the half-dozen warring factions cordial.
Maybe someone else steps up. Maybe not. It just gets rolled into the larger grieving process of the holes left by those we've lost.
My wife knows what hard copies (my "death book") to give him if necessary. Until I die he has no access, but once I do he has my implicit trust.
I don't keep the documentation updated as often as I'd like, but it doesn't drift much between update sessions either. A life event usually prompts updating the docs. The last time I updated was the night before going in for surgery.
Besides my self-hosted stuff, I do "family IT" too. The "family IT" stuff is all documented just like one of our Customers. I made a point of insuring that my business partner could take on the family in the same way that he could take on other Customers. The goal is still probably to wind down, but it puts the family IT on somewhat similar footing to the Customers.
Yeah that's the problem. They may have the passwords etc. but they don't have the knowhow to understand how the Proxmox cluster works, why the scripts aren't running, or comprehend an obscure error. It's basically a business setup at this point and would require someone with an IT background and lots of time to understand. Hell if you suddenly gave me such a setup and asked me to figure it out it would take a lot of time and trial and error as well.
The thing though is that if something happens the stuff won't all go down at once, there will be a process where hardware fails, subscriptions aren't paid, and so forth. So what I tell my family is to immediately backup the NAS files to external HDDs, create new email accounts with a public and setup forwarding for as long as it lasts (while changing their bank/Facebook/etc. to use those new emails), and so on. The telephone/internet providers may need to be changed to a user friendly residental service.
And all that has to happen fast before everything becomes inaccessible.
Internet account - they'll file paperwork to get access. They can continue paying the bills. Same goes for all utility accounts and online services (most of which is not a big loss - they can sign up for their own Netflix account if need be!)
Router: That's the main failure point. But they can just replace it with one the ISP gives (for a fee, of course).
Email: I have my own setup, so no one is impacted if I die.
Self hosted stuff: I think I'm the only user. Wife was using Plex for a while but doesn't any more.
Smart home: Yeah, they'll lose this. Stuff like smart switches "just work". But smart bulbs occasionally need to be reset and resynced to the hub. All in all, it's not really a great problem if they start failing.
I did add notes to my will on what I felt were the important files on my PC they may want to preserve (photos, etc). They don't use Linux so they may need help extracting them. Easy to pay someone to do it, but I have a feeling they won't really bother.
Also when one partner dies or is ill, the other often lacks the capacity (mental etc) to deal with complex technical stuff.
What about going on strike for a day or two? Not in a petulant way, but in a loving way. Just to impress upon your family exactly how important things are, that they're currently taking for granted. Maybe you'd get a volunteer to do some modest training and succession planning.
It’s really hard to force people to be interested in things that they aren’t interested in.
My family enjoys having a simple-to-use Jellyfin setup with Infuse as a front-end; but if I'm dead eventually that ZFS server will fail in one way or another, and they'll shrug and go back to streaming or buying DVDs or something.
Attempts to explain are met with "don't bother me with talking about you being dead".
I've tried to mitigate this risk by keeping a so-called "death book": a hardcopy of all accounts, passwords, 2 factor auth instructions, router SSIDs, and so on, kept in the firesafe with all the other important stuff. But this Reddit post points out that this is not enough! Someone would also have to come in and take over the technical toil and maintenance that it takes to keep everything running. Not sure what the solution is. The rest of my family has no interest in learning this stuff. They can't even remember their own passwords without me, let alone ssh to our VPS and restart exim4.