Musk went in thinking that $2T waste would be trivial to find yet fell so short of it that DOGE was disbanded within a year.
It was an idea that was never earnestly pursued and highly constrained by not being a formal agency with real power (see: reforming DoD or untouchable golden eggs), and all the transparency that comes with being a real agency with an explicit mandate... So it burned public trust pretty quickly.