In clinical trials around the world, a surprising treatment is showing promise for people with terminal illnesses: psychedelic therapy.