You're just unlucky. I've had a 93% chance of succeeding fail, I've also had really low chances of succeeding work (25% chance, and it worked). Indivi will be able to answer if it's meant to fail though. There's some stuff (dealing with the Succubus Queen) that even if you pass the check, you still need to go through with what the Queen has planned...