The disgraced constable resigned after being caught with content showing sexual abuse on his mobile phone