Sean Kirkpatrick has faced threats for his work – and a new report concluding no evidence UAPs represented extraterrestrial tech has sent ufology into a tailspin