I think you misunderstand. Survivorship bias in this context means we do not know all of the people who did LSD that did not go on to do anything significant. Therefore it is pointless to suggest LSD has overlap with "interesting people."
'Survivorship bias' is a misleading term for what you intend to imply, because those who have had a bad LSD experience are no less capable of sharing their intense experience except in the most extreme cases (i.e. when they didn't, in fact, survive). Personally, if I had such an intensely bad experience I'd be quite willing to share it so that others can avoid it. That is just not reflected the balance of stories I read though.