Fear of a ‘double-edged sword’ could backfire on affluent families ahead of the $84 trillion Great Wealth Transfer, HSBC says