Despite the low rates, Freddie Mac's chief economist said that some homebuyers are tiring of the competition.