Will Musk become the Great Leader thanks to DOGE? I don't know. I doubt it.
He's too much of a dumb thirsty edgelord. He'll get bored of the necessary administrative work, and focus on getting as much money out of it as he possibly can.
But keep this in mind. There will be somebody after Musk on that post. And nobody will be paying any attention to this silly-named, boring part of administration. Until, perhaps, there is no choice but to pay attention.