Why do efforts like Elon Musk's audit of government waste seem to fade away without results, and are they just for show?

Because they are just for show. That is what politics is: one big theater. Nothing that happens up in Washington, D.C. is real. It's all a show.