What was missing in your analysis - and may not be immediately available from the raw figures - was the working class vote, which has been the bete noire of the Democratic Party for decades.
The Democrats used to be the party of the working class voter since the Great Depression until the Vietnam War, averaging between 60 and 65 percent. Ever since 1972, the Democrats have hemmorhaged support from them, starting with those who voted for Wallace and increasingly leading into the Republican column. In 2020 Biden won but carried roughly 39 percent of the Working class voter.
The left has spent a lot of time arguing in favor of intersectionalism - as you discussed - and increasingly denouncing working class America. I have seen it even within Daily Kos which ostensibly is a mouthpiece of the 'progressive Democrats' yet loves to brag about the gains Democrats are making among the young, the educated and minorities - and says that Republican voters are increasingly not receiving college education. This is literally saying: Smart people vote dEMOCRAT AND uneducated ones are voting Republican and if that isn't the quiet part out loud, I don't know what is.
Kamala Harris lost, in my opinion, because of the mistake Democrats have been making for decades: they have increasingly used celebrities as their spokespeople and increasingly ignores the rights of the working class across every demographic. Besides that there were multiple hypocrisises in the election but the key one here is this: if you're arguing that the GOP is the party of the one percent and the major spokespeople for the Democrats are multi-miillionaires and celebrities, well, you can't exactly claim to be the party of the average American.
I don't believe sexism or racism was the main reason Harris lost, though it was a factor. No, it was the fact the same old story: the Democrats held to their old coalition and ignored the working stiff. All of the arguments about transferring wealth as some will suggest are fine ideas but will do nothing to immdeiatetly help the people who need the money and they are smart enough to know that even if the Democrats went full progressive. There's also the fact that the progressive message has never played in the areas the Democrats need to win to be competitive and that the left sneers at even the idea of campaigning in deep red states or for even centrist Democrats. aMERICA has been telling us that it doesn't want a full leftist agenda and the left keeps telling the Democrats that is what America wants; they're just too ignorant, or racist to know it. iNDEED they believe moving to the center means moving to the right when in fact its how governing works.
I will have my own series of historical articles about what I believe the Democrats need to do to win elections in the future. I started it this summer and now it is more necessary than ever. I won't deal with it until at least the spring but I do believe wokeness is part of the probkem and messaging far more important.