A search is resuming for a high-profile Queensland police officer suspected missing off the northern NSW coast.