Retirees could be depleting pension pots a decade too soon due to the lottery effect and impulsive spending habits.