As planning, analysis, and portfolio management get automated, the real value of an advisor is shifting fast—to emotional guidance, embedded insight, and decision-making support.