A senior PSNI officer has unreservedly apologised after admitting the police investigation into the death of showjumper Katie Simpson was not "rigorous enough".