It’s probably important to differentiate NN-DMT and 5-MEO-DMT. I’ve heard that 5-MEO is much more intense than NN-DMT.
I’m assuming that you’re talking about NN-DMT. It can definitely shake up the foundations of your world view, especially if not taken with the right set and setting.
I don’t think it’s as common with the pure form, but there is a slight possibility of it revealing some underlying emotional issues. There are plenty of functional professionals who carry some significant childhood traumas and issues that may bubble up to the surface through these experiences.