That works as reference to a frustrating situation, but Charlie Brown doesn't just miss. We assume that if the football was left where it was promised, he would have kicked it.

Maybe you suspect a similar situation with the Democrats, that those holding power sabotage their efforts, or maybe the analogy doesn't work in that way, but I think that people like this Charlie Brown trope because his failure isn't the result of a lack of ability; it's an excess of hope and trust.

I've heard plenty of people say that Americans are idiots because they don't realize the system is rigged against them and they believe the American Dream that anyone can achieve success. I think plenty of them know that the world is a harsh place with untrustworthy and adversarial people and that they are at a personal disadvantage compared to the wealthy and powerful, but they choose to persevere regardless because they believe hope is better than nihilism.

That can work against them. They might vote for a political party even if it fails them. I'm not saying that kind of hope is sane or rational from a game theory perspective, but it's very American to keep it up anyway.