The SEC is facing a staff exodus amid President Donald Trump and Elon Musk's efforts to remake the U.S. government, five sources said.