I definitely think that psychedelics can be a gateway to the astral plane. There are many denizens there and some are incredibly good while others are incredibly harmful. Most are rather neutral. I've met the goddess figure you speak of on a DMT trip myself. Or one anyway. Can't be sure it's the same one other people have. It was one of the most beautiful and enlightening experiences of my life.