Honestly, I think that was the reason for this episode: To show that John was like any other man - he had needs, flaws, and was in fact not the hero Dean always thought of him to be.

I think another reason for it was to further fracture the boys' relationship.