A detective from Northern Ireland who survived a murder attempt has said he feels “honoured” after receiving the King’s Police Medal.