The reality in the vast majority of places is that it is probably 90%+ in the cities and <50% in the middle of nowhere. Which is why the states without actual sizeable liberal cities like Arkansas, South Dakota, Mississippi, etc are so low. States with more liberal rural areas like New England and the West are so high would also make sense in that regard

Bigotry is a byproduct of stupidity, so it’s not surprising that there will always be a percentage of people who discriminate for stupid reasons. No matter how much education and guidance you provide to people, there will always be dummies in the herd.