They’re referring to Sony’s stance that all their PC releases should require you to have and sign-in to a PSN account. That’s separate to PS+, you don’t need to pay a sub.
A lot of publishers include this requirement on their PC releases, regardless of whether they’re single-player or multiplayer, and I think a lot of people are fed up with having to have so many different accounts.
Just make sure your family has a way to access your account. I very much doubt that Valve or most publishers will care that your kids have access to decades-old games after you’re gone. Although I could see Ubisoft trying to take action out of spite, but that’s only if they’re still around by then, they’re on pretty shakey ground at the moment.
Better option if this is an important issue for you is to only buy DRM-free. You’ll have to wait for most AAA games, but most AAA games these days are increasingly not worth it anyway.
I don’t think that’s their goal at all. Otherwise we wouldn’t see any sequels released on PC, that would be a much better strategy for converting players to console. The only reason publishers require their own logins in games, at least for single-player titles, is data collection. Data is very valuable.