"It gave me a new, intimate relationship with myself that I had never had before," the "Red Table Talk" co-host told People of the psychedelic drug.