People’s pessimism toward the housing market has hit a record high, according to a new survey.