I remember there was button to Roll Again after failed roll in few dialogues. I think this could work on Story mode. I would let e.g. three re-rolls and I believe most of the story-players will live with the final outcome of this.