This is a good observation. I think that “it works but we don’t know why” is appealing to a small slice of well-educated people who are comfortable with complexity and the limits of knowledge, but otherwise off-putting.
For most people I think that “it works but we don’t know why,” translates to “it doesn’t really work.” Thus a fake explanation adds credibility and believability. And if it does work, then people feel reassured and confident in the fake explanation.
It’s all pretty tricky human psychology though.