Sadly, that's what happened with Deus Ex Mankind Divided :(
We 9n era love linear games, those with an story, but the industry, and the game buyers, are going on a different direction.
It's true you can have success with those types of games, but it's much more difficult now, I think.
The problem with Mankind Divided was:
1) it was bad
2) no, really, so bad it actually ruined a bunch of people's saves, including my own, and I had to start over after 19 hours in the game
3) man, that ending, it was so bad
4) this is a game that takes like an hour to get going, with lengthy, dull cutscenes and frequently-interrupted linear levels
5) the game's focus on being in just one (incredibly small) location really hurt it
6) remember when the writers tried to make it about apartheid, but that didn't really work because people with cool robot bits whining that their bodies are cool robot bits comes across as disingenuous? (DEHR had way smarter plotlines, like the lady who felt she had to upgrade to compete, but couldn't afford expensive implants)
7) remember when the "augment your preorder" campaign backfired and upset a lot of people?
8) Remember when they added in a really un-fun side mode that wasn't exciting and nobody liked it?
It didn't really have much of a narrative hook, it didn't keep itself exciting, and all the technical issues early on led to a ton of complaints which killed its chances at success. It didn't help that hyperbolic YouTubers like Jim Sterling were out there making up shit or repeating bad rumors about how the game had been split in half (it wasn't) and the second half would release like a year later or something (which didn't happen, as you all know).
Mankind Divided didn't fail because it was single-player, it failed because it sucked. It sucked because it didn't have a solid, clear vision about what it wanted to be, and a lot of the ideas it did have were genuinely bad ideas (like the apartheid and augment your preorder stuff, as well as a bunch of huge, ultra-linear missions like Golem City).