Sorry I missed this comment before! My (admittedly silly) idea here was failing your sanity save allowed the character to tap into their nonsense religious beliefs, put aside reality momentarily, and calm the crew down. If they pass, they properly assess their situation and just get more stressed out.
I could totally see just flipping that if that doesn’t make sense to you though! Appreciate you checking it out regardless.