The unnamed security chief completed his final duty during the King and Queen’s state visit to the United States this week