You can’t sell or transfer accounts, and upon the death of the owner of each account, the account will be closed and licenses to games revoked. So yes, effectively, they will have accounts with a general “time limit” for existing

How does that work with the family share games option in the Steam client?

If they’re playing a shared game does it just disappear on them all of a sudden?