No, I have no idea why Horowitz is leaving the agency. I do know, though, that the story about “spending more time with the family” is usually code for something else. He obviously knows things about The Shaft that the rest of us don’t, but it’s not obvious that he’s a rat leaving a sinking ship. On the other hand, it’s certainly possible.
Also, I’ve heard rumors that one of the names in the DC madam’s little black book was a high-ranking NASA official, but again, no particular reason to believe that it’s him, even if they’re true.
Either way, as Thomas James notes, it would be nice if he’d take his toy with him, but it’s unlikely.
[Update a few minutes later]
Chair Force Engineer, who has been speculating about Orion’s mass issues, has further thoughts.