It absolutely is NOT normal. They have very strict fatigue tracking and rules. This guy shouldn’t have been anywhere near a cockpit. I’m not sure if the rules extend to non-flight crew but I’m sure the FAA will be considering that now.
And this dude hadn’t slept in 40 hours. Who the hell take mushrooms for the first time with severe sleep deprivation while in the cockpit of a commercial airliner!? This guy was unstable to begin with. Hopefully this doesn’t set back the public and regulatory perception of psilocybin and all of the therapeutic benefits it has.