I seriously wonder what this Catholic priest was thinking.
According to a natural law view, the reason for taking a psychoactive substance is a major component in determining whether taking it is licit. A bad intent corrupts the act. So, if I have a martini in order to calm my nerves, or choose to savor the goodness of a glass of beer, then knowing what we know about the effect of alcohol in moderation and our own personal response to the quantify in question, there is nothing wrong happening. (Catholics are not teetotalers. We like our wine.) Indeed, if you are in a state of high anxiety that impedes the use of reason, taking something to calm your nerves would be therapeutic and restorative. But if we consume alcohol in order to get drunk or buzzed, then this is morally illicit, as the intended effect — the distortion of perception and the impeding of the operation of our rational faculties — is immoral. This is because, on a natural law view, our nature is to be rational animals — to know reality as it is, which is what the senses and reason are for — and to intentionally thwart our nature, and especially that which is most essential to our humanity, our rationality, is bad for us as human beings. (It also produces emotional distortions, which are, again, something bad for us.) That is why it is an affront to human dignity to trip, and we intuitively perceive this when we see a drunk or someone who is high. They disgust us, they arouse pity in us, or, in less serious cases, we laugh at them, because the comedy is the result of them failing to be rational and thus human.
The principle of double effect also tells us how and when taking a substance with harmful side effects is licit. The intent is, again, an essential component, and recreational drug use is simply never licit for that reason as explained above.
The idea of using drugs to produce a “spiritual experience” is also nonsensical. That is because it isn’t a bona fide spiritual experience. It is a hallucination, a corruption and suppression of the perceptive and rational faculties which is how we come to know reality. It does not clarify our perception of reality per se, but darkens it by producing mental and emotional distortions. A true spiritual “experience”, if you want to call it that, would involved the heightened or elevated operation of perception and rationality, not their diminution. So the real McCoy is exactly opposite. That people subjectively report having gained insight is either a side effect of the hallucinogen disrupting some pattern of denial or whatever, or merely an error of perception (which is expected, as people high on drugs aren’t thinking clearly and have a poor ability to appraise the validity and value of their thoughts).
True spiritual maturity is sober. Hallucination is the exact opposite of sober. It is a fraudulent ersatz, not some royal road to the divine or whatever.