I felt really sorry for Oreki, everyone had such high hopes for him to solve the mystery and he couldn't match their expectations at first.

They encouraged him to help and for the first time he began thinking about it seriously and really tried to help and it ended in a (for him and his friends that is) wrong way.
then after realizing that he was just being used under a false pretext, he must have felt even worse