The majority of Americans say that they expect to rely on Social Security benefits once they retire, but that they are afraid benefits won't be there for them, according to a new survey.