Today Elon Musk is for it, tomorrow he may be against it. The only thing I know about him is that he is a businessman, and the essence of a businessman is to chase profits.
To put it bluntly, Elon Musk is just using the crypto market to make money. Don't think he is so great.
He did that with Bitcoin but I doubt he will do that with DOGE as well. It seems he is really determined to do something with DOGE although nobody understand yet what that could look like. He is always in for surprises as we know, but I prefer to watch from the sidelines. Maybe it is only for the lolz what he has in mind, but maybe he seriously considers putting billions into it and prove the world wrong again about his abilities when it comes to a damn meme coin.