At a national level, I think some of it just comes down to resentment at popular policies being blocked, largely because of lawmakers from southern and midwestern states. I’d also wager context plays a part in this. Sure, NY has its share of rural Republican voters, but our dumbfuck GOP voters mostly manage to just mess things up for our own urban areas, appropriating funds from the MTA budget to build bridges to nowhere in their home districts so they can point and cry about those god-damned socialists in NYC not even being able to manage the budget for a single agency (that they actively work to undermine) so they can further gut public services.
Sure, it’s not ideal, but at least we’re (mostly) only hurting ourselves. GOP Congress-men and -women from southern and midwestern states collectively hold the rest of the nation hostage through their disproportionate impact on the Senate. Whether it’s climate change, student loan forgiveness, universal healthcare, packing the Supreme Court, or any of numerous other issues, these states hold others with vastly larger populations hostage, impeding broadly popular policies in a profoundly anti-democratic fashion.
It may not be fair to the non-GOP voters in those states, it may be misdirected resentment, but I don’t think it’s all that difficult to understand why people from majority Democrat, northern states might be kind of tired of the south and midwest’s collective shit at this point. If the GOP-leaning demographics in those states could either be dropped into a volcano, or, failing this, soundly beaten at the ballot, it would go a long way towards addressing this stereotype
They may be idealists that don’t reflect a use case I think is reasonable to expect of the average user, but I would also say that it’s very important to have them there, constantly agitating for more and better. They certainly don’t manage to land on achieving all their goals, but they also prevent a more compromising, “I just need to use my stuff now, not in 10 years when you figure out a FOSS implementation” stance from being used to slowly bring even more things further away from FOSS principles in the name of pragmatism.