Dude! Are you using SIE's figures during a console launch year?
Here, take a look at this:
Do you notice the pattern for FY95/96, FY00/01, FY06/07 and FY13/14? Console launch years have always been years where SIE loses money due to the massive investment required. Now look at FY20/21 where the PS5 launched and where you're pulling your numbers from. Not only did SIE manage to finally break the cycle of losing money during a console launch year it was actually their most profitable year in history. The SIE figures you're using are heavily weighed down due to having to absorb the cost of launching the PS5.
It's crazy how good of a situation SIE is in right now and how much they have to invest in M&A in a strategic way.
Just like how I rank their purchase of Insomniac higher than Microsoft's purchase of Bethesda, as long as Sony makes careful and strategic acquisitions they're going to be better placed to get a significantly higher return on their investment than Microsoft has with their 70 billion dollars in Activision and Blizzard. The slew of developers there is certainly on the decline as are their IP. Could they do better under different management? But look at the difference in Bethesda and Insomniac games.
Insomniac
Spider-Man Miles Morales
Ratchet and Clank Rift Apart
Spider-Man 2
Wolverine
Bethesda
Starfield (Bethesda)
Elder's Scroll VI (Bethesda)
Wolfenstein 3 (MachineGames)
Indiana Jones (MachineGames)
I have no doubt that Starfield and Elder's Scroll 6 will perform well. Wolfenstein 3 and Indiana Jones are kind of whatever, maybe they'll perform well, we'll see.
But on the total, does ANYONE expect Bethesda's slate of games to significantly outsell Insomniac's? Does anyone think they'll outsellf Insomniac's at all? First, you have to assume that ES6 performs as well as Skyrim despite no other entry in the franchises performing that well. Then you have to assume this without it being on Switch and PS5. That may cut half of its sales right there. Spider-Man sold 20 million on PS4 alone. And will sell even more when ported to PC. Wolverine will likely not perform AS well as Spider-Man 2, but it should still be a strong performer 10-15 million. Then account for the fact that ES6 isn't even in development yet, so it probably won't come out for another 5-6 years. Insomniac will still have more games out between Wolverine and ES6.
Now remind yourself that Insomniac was purchased for 229 million and Bethesda for 7 billion.
Sony can EASILY buy enough development studios and maybe publishers to equate to the sales of Call of Duty and any Activision Blizzard IP that it might miss out on due to exclusivity. And it won't cost them more than a fraction of what Microsoft just spent.
Let's assume for a second that EVERY call of duty does as well as Black Ops 2 (which they don't) and sells 30 million units.
Kadokawa - Dark Souls (though they wouldn't own the Dark Souls IP) - 10 million (have to remove xbox sales) - 3 billion dollars
Capcom - 6 billion dollars (Monster Hunter World - 17.5 million, RE7, 10 million, Street Fighter 5 - 6 million, DMC5 - 4.7 million
Sega - 4.47 billion (Persona 5 - 4.6 million)
Then you get into smaller purchases like Kojima Productions, Acquire, Remedy e.t.c.
Buying big publishers just isn't a wise investment. I would even say dropping so much coin on Kadokawa, Capcom, and Sega wouldn't make sense, when building organically is way cheaper.