You're right, I agree with you and I think his goals are both damaging and stupid... but at the end of the day his strategy is winning and we will obviously have to adapt to beat it.
Biden wasn't really a centrist in the same way Harris was. Biden ran on a progressive-ish platform, and mostly backed it up with action. He sure as hell didn't run on fracking and locking up immigrants like Harris is.
The Dems should definitely move more central on social issues, as the US election system has a huge built in rural bias.
Then focus on more broad-reaching progressive economic topics. Less focus on legislation targeting specific marginalized groups and more on policies which would impact everyone directly. As a potential example, Universal Basic Income ("Freedom Bonus" or whatever it was called) was one such policy which was floated a couple elections ago.