DMT can be an enjoyable drug and similarly to LSD you may have minor hallucinations. You may also experience a 'reset' when you finish coming down from the high. However, this doesn't mean you are guaranteed to find your life's purpose while on the drug.
There may be a grandiose idea of what you should do with your life but these ideas may be far from achievable or sustainable. If you'd really like to know what to do with your life, find your passion and figure out how to turn that into a career.
The effects of DMT can be similar to the effects of LSD in that the high can lead to hallucinations, irrational fears, and an overall distorted sense of reality. Some people claim to discover their life's purpose while on DMT or other mind-altering hallucinogenics. Whether these ideas are sustainable or achievable in reality is another question.
I cannot say whether you will discover your life's purpose while on DMT, but I can caution that the use of the drug can be dangerous and you should not make any major decisions about your life while you are high on DMT or any other drug.