I've lost count of the times my buddy and I wanted to play coop, and I was forced to log in to my ms account for a split screen game. I remember back on the original xbox, and x360, using 'guest' just worked. Forcing people to login for couch coop is asinine.
I wonder if this one is actually deliberate as a slop-pushing thing, or if it's actually a developer level thing where some devs assumed every player has an account.
It definitely depends on the game. Some allow second (or third or fourth) players to play as "guests" (not signed in to any particular account), and some don't. Party games, or games designed primarily for co-op, are definitely more likely to allow guests.
Weirdly, in my limited experience it seems that 'premium' / AAA games are more likely to require an account - I suspect it's because they want to be able to save unlocks/progress for those players. Perhaps they think it will incentivize those players to buy a copy of their own.