“The officer had both hands on the roof to get up on the roof [but] never made it because the shooter had turned towards the officer, and rightfully and smartly, the officer let go,” Butler County Sheriff Michael Slupe said