‘Intoxicated’ police officer who grabbed colleague’s groin and said ‘you know you want to’ dismissed