Actually remember seeing some numbers on this a while ago and I was pretty shocked at how few games the average person buys. Like median ps3 owner bought 7 games over the life of the entire console.
From looking around google quickly it looks like the average for ps4/5 is 6-10 depending on region.
So if someone stays subscribed to the service for the life of the console then Microsoft comes out way ahead compared to just selling games, I would guess