Have i messed up or was he just after sex anyway?

He probably thinks you're psycho after that last little thing he went through with you. That was probably the last straw for him, so he's decided to move on to greener pastures.