Cong. Tom Rooney 'pretty emotional' about shooting, he told CNBC