Same happened for me. It started with the Thai cave rescue and his submarine where it showed that he is a big attention whore. From then on he seemed to lose his mind.
I still have to respect Starlink, accelerating adoption of EVs and the work SpaceX does. His businesses have reshaped several industries big time. It takes a lot of courage and insight to pull this off.
I could imagine that Musk's political escapades have driven away a lot of people.
SpaceX may also have lost Musk as the referee who makes quick decisions and keeps things moving forward. I think people like Thorvalds, Gates, Jobs and Musk are a superpower for organizations. Their decisions may not always be perfect but at least a decision is made so people can proceed. Otherwise you end up with the usual committee decisions that take forever and are mostly driven by internal politics and not about the product.