I'm not sure why publishers all seem to be chasing this golden unicorn that is live service games when only a few have actually had absurd amounts of success. Making great single player games with a good narrative can sell games too, especially if it's a big IP. Just look at how ridiculously well Hogwarts Legacy did, over 22 million copies sold and as far as content goes, it is actually very lacking in terms of depth of the content outside of the story, but the gameplay is fun and there's a huge fanbase for games like that.