A third (34%) of affluent retirees say they expect to pass on more of their wealth than they would prefer when they die, according to a new study.