There's a disconnect between what near retirees expect from Social Security in retirement and what the program provides, a new survey finds.