My opinion probably doesn't matter to the commenter before you (because I am also from the shudder US South), but I think a few things are true here
First, I agree that 24 did have mainstream appeal regardless of political ideology. Pretty much everyone I knew watched it.
Second, the appeal was not solely grounded in "Torture is good". I walked out or closed my eyes on a lot of those scenes, but watched the first few seasons because I liked Chloe's character and because the the format (every episode as one hour of the same day) was novel. Also because it was something I could talk about to friends and family - back when we all consumed the same media regularly.
But if you think back to the Bush years, it really wasn't until after the Iraq war, and Abu Ghraib in particular (2004), that democrats started to come out more vocally against Fox-news approved "enhanced interrogation". It wasn't that they were also pro-torture before, but I think it felt more theoretical to Americans on both sides back in 2001.
Later on anyone who was paying attention had to confront the reality of it. That's when the sides splintered and the Fox-news machine ramped up on normalizing/praising abuse and characterizing every individual ever captured as a blood-thirsty future Bin Laden. Relatedly, Gitmo was a huge deal to the dems back then, even Obama campaigned saying he would close it (it didn't close). He may not have won the nomination without that promise though.
So it was a real dividing line for a moment, but ever since the financial mess of 2008, the democratic voter base has been more engaged on economic and healthcare inadequacies, so when those took over the news, the party was grateful to not remind people about gitmo.
I will say there were pro-torture, war-hawk dems at the highest level. That's always been a problem for dems. But the tone on the ground was very consistently anti-Bush, anti-war, anti-torture (for a moment at least).