I got caught smoking weed and drinking when I was 17, and then got fooled into admitting I took ecstasy at 18, so my parents were scared. Shortly after this time I started tripping. I certainly did not tell them about it for quite a long time, but I remained close to my parents, they didn't have some moral dilemma, they weren't scared I'd get a bent spine or go insane or other such nonsense, they used to smoke weed in college sometimes and were close friends with people who used drugs. They just didn't want me getting in trouble, and some of my older cousins ended up having some bad addiction problems so they were scared about that too. When I was 25 or 26, I was talking to my mom on the phone about religion for a long time (she is Christian and very passionate about it but she's the type of Christian who believes Jesus was a radical hippie and wants us to love everyone and that hell isn't a real thing), and I felt comfortable telling her about my first mushroom trip. The reason I did is because she was concerned about me being non-spiritual, like my siblings ended up (and I was before I tripped). I thought she might be freaked out, but I told her anyway, and she was really interested and told me it sounded like a good thing for me, as I told her about all the ramifications of it in my life. She seemed fascinated that some mushrooms could have connected me to "god", even though she maintained that she believes god is a singular entity pulling the strings, but she felt it was a good thing for me to believe in being a part of something bigger and to be a good person who is aware of things. I also told her I have had a few other trips. I never told her the extent to which I have done it.
A couple of years after that they found out about my long-term opiate addiction and were very scared, but they also helped me a lot. During that time my dad made me promise not to use any drugs again, it really scared him a lot. I didn't keep that promise, but I did get off opiates and showed them over time that I was good, and I think my mom has full confidence in me and my dad pretty much does but he's still scared. I know my mom knows at least that I smoke weed sometimes, and alcohol is no worry of theirs, and my dad probably knows too but he can see I'm good. I have never told my dad about psychedelics and never will... my mom may have told him about it, or maybe not. He is just kinda dismissive that drug experiences could be valuable, it seems. Plus I could always talk to my mom about more things. I may or may not share more about it at some point with my mom, but not sure what the point of that would be. If she asked I would have no problem telling her that I still occasionally use psychedelics. My dad has ALS and probably has another year or 2 at very most to live... I'm sad that I won't ever share it with him, but it would only worry him and our relationship is very good, and I don't want to him go out of this life worrying about me...
Basically my parents have been quite understanding, moreso than I expected they would when I was younger. I haven't told them the extent of my drug use at all, but my mom supports the idea that psychedelics can be useful tools for personal and spiritual growth.