With affluent consumers seeking an emotional connection and alignment with their values, these demands require real estate agents to evolve.