Americans are souring on the tech billionaire, whose DOGE leadership has drawn strong opposition from many Democrats.