I believe the INTJ deep-down wants the relationship, but he is too afraid of being burned so he has numbed his feelings and decided it's better to be a mere friend. The fact that he keeps saying that he's bad in relationships points to a fear of intimacy. He wants it, but he's afraid of it.