Meghan Markle and Prince Harry's closest advisor, James Holt, has quit his role as head of their charity, Archewell, having guided the Sussexes through rough periods