I was a Biden voter, but he was a weak and deeply disappointing president who exercised awful judgment on multiple occasions: running for re-election at his advanced age, not sacking Lloyd Austin for either the disastrous Afghanistan withdrawal or going on cancer leave without telling anyone, not taking the lead on ending the COVID emergency (Colorado's Jared Polis was ahead of the White House on that), having so little control over White House interns that they released open letters against official Biden Israel policy, failing to take inflation seriously, etc.
Republicans are awful, but Democrats don't seem to want to do any better than "at least we're not them." It shouldn't be any surprise that Trump has (had?) real appeal over feckless national Democrats.