There are already completed studies that show positive impact from psilocybin on anxiety.
My experience as someone who has mild anxiety (and always feared having a "bad trip") was that, though I had some challenging and uncomfortable (but ultimately rewarding) thoughts during the experience, the "afterglow" was a couple weeks of enhanced mood and little-to-no anxiety.