Superintendent Stephen McCauley, who heads up the Dublin Metropolitan Region Roads Policing Unit, opened up about the tragic officer's passing earlier this year