One of NSW’s most senior detectives described the former Australian Federal Police officer’s alleged offending as “abhorrent”.