The fact that he wasn't very good at it doesn't mean that Epstein wasn't Mossad and passing blackmail material to them.
Reading up on CIA antics shows that most intelligence operators are completely out of control, with no fucking clue what they're actually doing, but with the self confidence of a sociopath who doesn't understand the consequences of their actions.
The spy and analytics side is often better, but every time agencies try to shape events, they create blowback. Especially since they think that working with people like Epstein is a good idea.