I don't think there's anything broken just because you feel both sympathy and resentment for the same people. The real world is complicated, and it's good that you're able to admit that you have this internal conflict.
I will point out that there is one big blind spot I'm seeing in stuff like this. I suspect that you're conflating middle class white voters in conservative cities with poor rural white people and lumping them all together as "white rural voters". You shouldn't assume that they're a bloc, even in California lots of people are conservative and vice versa.
Every state has lots of open minded people who just want to find joy in their lives like everyone else. I grew up in Indiana, and if we want to go full anecdote, one example is my Boy Scout leader saying he'd stand by me against the national organization's anti-gay policies if push came to shove. Or NOBCChE letting me in because there was no other way to do the science fair at my high school. They didn't even tell me what NOBCChE stood for, and somehow I literally never noticed that I was the only person there who wasn't black. There are good people everywhere. Everywhere.
I have very little resentment for poor white people. I am very resentful of well off people voting for their own power, comfort, religious authority, and low taxes over the well being and safety of millions of people.
The data is enlightening, and I'll refrain from editorializing it:
http://www.cnn.com/election/results/exit-polls
So yeah, I'm very sympathetic to anyone who is having a hard time. Especially those who see no way out. But that doesn't mean I'm okay with things that hurt me and my friends -- especially when that pain inflicted does nothing to actually alleviate anyone else's problems.
Kicking out immigrants or forcing gays into the closet or preventing transgender people from using the bathroom or preventing minorities from voting or making Jews fear for their lives won't help the opioid crisis or provide financial security. Treating these things like they are in any way intrinsically related is a huge problem in framing that results in poor tactics.