Not for me, no.
It's story is really as convoluted as any other Kojima project. That is to say, it's a lot of extremely long cut-scenes and exposition about nonsense that you'll fight to keep from nodding off on after awhile. If a critic's issue with the game is the story not having some twists and turns, yes it could change their opinion one way or another. But if you don't enjoy the minute to minute gameplay experience, nothing story-related will redeem your time spent.
For me, I mostly enjoyed the story. The major beats are good, I thought. The minutia often gets lost in the weeds trying to lather you up for a premise that is mostly nonsense. I enjoyed everything about the gameplay *except* the vehicles (awful experience overall) and the 3rd person shooter mechanics (camera control just not refined enough).
One of the later chapters was almost 2-hours worth of exposition and cut-scenes with no meaningful gameplay at all. Kojima needs to learn how to break this shit up sometimes. He's been doing this since MGS2? Certainly since MGS4. It's just too much for a sitting without giving a player some sort of warning it's about to happen.
But no, IMO the ending won't turn a game someone likes into one they dislike...or turn a game someone dislikes into one they suddenly love. I was expecting to not like this game. Ended up liking it quite a bit.