When it comes to the so-called Great Wealth Transfer, “I don’t think people should count on it,” one financial adviser says.