Since your kids are young I would live there for a few years. But definitely come back before the kids gets too influenced by the non transplant conservative people there. I say this because you mentioned you guys were moderate, liberal, atheist, Jewish.
The museum is amazing and I would love to work there. I’m a mid century modern fan and would enjoy visiting the sites here:
https://fayjones.uark.edu/news-and-events/publications/mid-century-modern-architecture-in-northwest-arkansas.php
We learned about the Cooper Church in architecture class. I’m digressing, but I tried living in Syracuse, NY and hated it. It’s supposed to be a decent city for people who enjoy the outdoors, but people there are very provincial minded. I was used to living in huge cities, liberal, very well traveled, non-white ethnic background, atheist. I did not fit in at all. I tried, but they were not open to outsiders either.
Also, I lived in another country (won’t name it) when I was in elementary school. It influenced me to be pro-that country. A lot sticks to you even as a child. In short, you could relocate as long as you have an exit strategy for after a few years if not sooner.