Hello traveler,
Thanks for sharing yourself with us. Seems like you're already on a good mental path in life. However the questions you ask are not easily answered, simply because we all react differently to different stimuli.
Regarding point 1, I don't think DMT or any other entheogen will alleviate the feeling of desperation when looking at mankind's self-destructive trajectory and behaviors. On the contrary, entheogens may even intensify this feeling. But the ever-present balance can not be disturbed by nobody and nothing. Along the bad comes the good as well. You will most likely gain new perspective on people and will be better suited to place yourself in their shoes and experience life from their perspective. This level of emotional understanding definitely helps alleviate the pain that being aware of society's flaws causes.
Regarding point 2, I don't think a profound spiritual experience has the power to negatively affect your creative side and destroy the passion you have for something you do. On the contrary, it might make you even better at what you do. Many people have experienced this. Some with writing, others with music etc. You will never know until you try. The concept of money is not inherently a bad thing. It's the execution that sucks.
And finally about point 3 - I wouldn't believe in such things. If you love your wife and your son, no entheogen will make that disappear. It might strengthen your bond with your family, but it won't destabilize it. You made it possible for another physical vessel to carry the magic of existence and consciousness inside of itself. In a sense, you gave life. There are few things more precious that that, and I trust DMT will remind you of this and help you appreciate it even more.
Finally, go into those realms not requesting answers, but rather seeking help to ask the proper questions. A new direction in life. New light shed on everything. New questions to be asked. A new path to walk on.
It may change your life completely, or it might alter your perception just enough so you can learn to truly appreciate what you have, who you are and what you gave to this world to make it a better place for everyone.
I send you love and support throughout your future journeys. Be sure to share with us.
With love and gratitude,
Nydex