The Great Wealth Transfer of trillions of dollars among high-net-worth (HNW) families is happening, according to a new study.