I don't think that's "the problem". There's plenty of demand for the cars. Elon Musk fatigue may be a real thing, but that's more related to the news cycle (and the Twitter cycle), in my opinion, than Musk himself.
I wonder why the media new cycle keeps making him say outlandish stuff! What do the majority of other company CEOs have over the entire industry and Twitter to somehow appear to be quietly doing their job?
If you cry for attention when times are good, you shouldn't complain about attention when times are bad.
I expect to see that demand shrink. If I find his behavior lately to be weird, I think that other people will as well. I'm also perfectly happy to vote with my dollars.