I'm glad you asked about the deleted Pompeo tweet, ouais, as I was a bit befuzzled too, and that Business Insider link about his confirmation hearing has helped.
So if I now understand aright, Pompeo either saw Wikileaks as a trustworthy source, which would put him at odds with the assessment of the CIA he was about to become head of.
Or he didn't see Wikileaks as a trustworthy source, in which case he had deliberately propagated material he didn't believe was true, for political gain.
In his confirmation hearing he admits – indirectly – to the latter.
It's not a good look for the head of the CIA.