In literature you have to do two things: tell a story and do it in a pleasant way. If you fail at telling the story, you fail at it.
Games have much more to them than just telling a story. You have mechanics, you have visuals. It is interactive and it has outcomes.
To not fail a game you have to give player satisfaction.
It would be nice to think of all of the things that might appeal to players, the story being just one thing among lots of others.
If story would be the only important thing then people would play lots of text based games but they do not.
The bad thing is that most of the times players get what designers think is a good game, not what they actually think it is a good game.