I don't want to give Musk any real credit. Nor do I want to be insensitive to the real issues that trans people face daily. But a lot of people, maybe even a sizeable majority of people resent being asked what their pronouns are. I'm of the opinion that the more this is forced on the majority, the more the trans community will suffer. It guarantees a backlash. I'm the biggest believer in live and let live. As long as you don't harm me and mine, why the ◊◊◊◊ should I care about your gender identity? If I identify you wrongly, correct me and I'll try and respect you as a person and refer to you as you want me to.
But the need to proactively asking every new person you encounter about their preferred pronoun comes off as unnecessarily absurd. We take our cues from appearances. When someone looks at me and asks me my pronouns, I can't help but think, "are you stupid?" It comes off as a needless redundancy. And more importantly, many people resent the hell out of it.
From my perspective, this only gives straight, average people a reason to hate this group of people they don't understand.