I mean, that's not the CIA's choice, is it? Cannabis is, for now at least, still a federally prescribed substance. I don't blame them for not wanting employees that break the law.
I bet as soon as the law is changed they'd welcome you with open arms.