it is absolutely not useful for gaining anything outside of what you consciously already know, but for whatever reason can't "wrap your head around"
Lots of weird comments in this thread trying to assert anecdotal experiences and opinions as a blanket truth. There have been lots of stories where trips have been able to bring the subconscious to the surface and given light to underlying truths hidden beneath
While I still believed I was cis, I displayed lots of behaviours for years that I was obviously trans (debating with my male friends that being a girl is way better than a guy, being happy whenever a friend would say I have the personality of a "cute girl") but I never once questioned my gender identity. My first trip (shrooms not LSD tho) I experienced explicit gender dysphoria for the first time ever and it was incredibly intense to the point of wishing self mutilation
The intoxicated hyper awareness combined with the increased neuroplasticity can absolutely make one gain useful insight that they've never once came close to grasping