I don't share this experience. Some experiences stick but for me overall after a week or so a lot of the "revelations" seem pretty crackpotty.

However the older I get, the more useful the 'revelations' (I rather call them insights) become. As in: I can actually use them to do things better in daily life.

What it offers, though — in the only way I know how to describe — is an alternative perspective. It’s like stepping outside of your usual self and evaluating things from an almost objective and completely different point of view. It’s this perspective that allows for revelations that otherwise wouldn’t happen in a sober state. This is a result of physiology and the chemical interactions in the brain due to ingestion of the substance.

It’s quite an amazing experience. Sometimes it can be scary, or odd or just funny. But in my experience, it has led to some very profound experiences and insights.

It made me pay attention to different things than I would normally pay attention to - things I arguably should have paid more attention to. Specifically social cues. I would repeat peoples words in my head over and over. I would go over written words and try to imagine the tone of voice very carefully.

It also made me change my behavior (temporarily), partly as a result of the different way I was paying attention. I got to see how people responded to that changed behavior (they responded very positively).

It's absolutely possible while sober, but it can be quite effortless and accidental on a trip. I'm also not so sure all people have these experiences while sober, even if they could - it takes work. Psychedelics can be good at breaking down mental patterns and guards, exposing the things you typically miss or avoid.