A prominent Queensland police officer is missing off Broken Head in northern NSW.