And the parts that might be annoyed at him for Twitter are entirely unrelated to those dealing with space.
Sadly "The government" is hundreds of separate organizations, agendas and politicians all with separate cover their ass agendas, NASA probably want this to succeed, I doubt the others are as enthusiastic.
NASA, the military and security services
“Sadly”? Would the alternative of a monolith be preferable in a pluralistic society?
What reason would the other parts of the govt have to want Musk to fail?
The public isn't though. Most people outside of twitter don't have any opinion on him.