Ah, gotcha. Like a kombucha sorta deal? Psilocybin would be a pretty bad alternative to alcohol haha, very different experiences. Though there are a lot of alternatives out there that are easier on the body. Kava, kratom and amanita muscaria come to mind. They can all be brewed and have a long history of use for intoxication.

Amanita is a bit contentious (it’s either slightly less or just as toxic as alcohol) but it is a fungi that is brewed into tea. Not really fermented but it’d be easy enough to carbonate if one were so inclined for that acidic edge. If it’s something you’re interested in, check out a kava bar sometime if you have one nearby. They usually serve kava, kratom, and sometimes CBD/THC depending on your area