People joke about fatuous "meaning of life" insights. But in my experience, you often do see "the big picture" of your life, and of everything. However, it's hard to remember stuff like that. And it fades pretty quickly, back into the slog of day-to-day life. I also got that from doing work with est/Landmark, NLP, Tony Robbins, etc. Not that they encourage the use of psychedelics ;)

I'm reminded of Tool's "Rosetta Stoned".[0,1]

    ...
    10 to 2 AM, X, Yogi DMT, and a box of Krispy Kremes
    ...
    When a flaming stealth banana split the sky
    ...
    Then the X-Files being
    ...
    Did a slow-mo Matrix descent
    Outta the butt end of the banana vessel
    And hovered above my bug-eyes, my gaping jaw
    ...
    He said, "You are the chosen one
    The one who will deliver the message
    A message of hope for those who choose to hear it
    And a warning for those who do not."
    ...
    See, they took me by the hand
    And invited me right in
    Then they showed me something
    I don't even know where to begin
    ...
    Can't remember what they said
    ...
    Overwhelmed as one would be, placed in my position
    Such a heavy burden now to be the one
    Born to bear and bring to all the details of our ending
    To write it down for all the world to see
    But I forgot my pen
    ...

0) https://www.youtube.com/watch?v=VZXJLQntCP0

1) https://genius.com/Tool-rosetta-stoned-lyrics