Bite my shiny metal cockpit!

Lego games are not even big sellers to begin with, and I think most of us all agreed upon announcement that there was little to no overlap between Horizon and Lego fanbases to begin with. If they want to explore expanding the IP then they can do that: after all there isn't just the 3rd mainline title in development, there's the MP title, a mobile MP title and a movie. 

I'm not even sure why you compare Horizon Lego to Star Wars: the latter is legacy IP that is still incredibly popular today, and the game itself contains all 9 movies in it, Horizon was just the first game. 

And who actually thought the VR game was going to make a splash? It's a lunch title for an expensive set of hardware that requires an expensive PS5 to buy first.

I'm sorry, but these critiques into Horizon are incredibly reaching. If the MP game gets cancelled then so be it, but a Monster Hunter-like where you fight robo dinosaurs/ animals has a lot of potential. 

They don't have other upcoming games announced. 

ND are seemingly working on a new Unchartered with TLOU3 afterwards, on top of Intergalatic. Cory's new game for SMS is most likely SP. Suckerpunch have GoY coming out. Insomniac's next game is Wolverine, with rumours that SM3 and a new Ratchet will follow. Guerilla definitely has Horizon 3 in the works. FireSprite are heavily rumoured to be doing Until Dawn 2. MM and and HM are up in the air for now. This of course doesn't take into account colloboration efforts like Death Stranding 2 and Lost Soul Aside, with Sony rumoured to be working on a handful of smaller titles as well.

Of course, as we know, rumours don't pan out as we expect them. But it's not like everything we know is confirmed is just live service. 

And can't say I agree with the assessment here on Horizon. What we learnt from the Insomniac leak is that HFW sales were knee-capped by it being released on PS+ so soon after launch. Sony has the data to prove this, and we know this as well. There's a reason why we haven't seen any other first party game hit PS+ as fast as HFW did because of the knock-on sales. And everything surrounding MS and GamePass should make this incredibly obvious: games on subscription services have negative effects on the actual sales of said game. So, using HFW as an example of franchise popularity I think is a fool's errand. And of course, the remaster for HZD debuted in top 10 in UK. 

As for Marathon and Fairgame$, I doubt either of these are being cancelled as I would imagine they are much further along and, more importantly, officially announced games. I doubt Sony's ventures into live service are ending, they're just reassessing them with more scrutiny now.