So my experiences regarding success rate have been more positive than yours, but yeah, with a real mystery it is perfectly possible outcome that the characters fail to solve that. If one doesn't want such possibility, then one should not run a game that way.
My solution to this in my D&D game...