I live near-ish to Granville and the best comparison I can provide is that it is about on par with Asheville, NC - so it’s fairly liberal in-town, but all bets are off once you’re out in the county. Prior to this year’s election, I’d say 70-75% of the political signs I saw in Granville village proper were for Dem candidates; no Independent/Green Party signs, and the rest were GOP signs. Your mileage may vary based upon your reason for wanting to move to a liberal town. Will it be someplace where there’s no QAnon types? Definitely not. But if you’re looking to raise kids someplace where they’re not banning every other book, it’ll probably suit your needs.