Retired people look set to bequeath rather than use most of their wealth