Keep in mind, I live in very conservative SE Ohio, the middle of the so-called "Bible Belt." Some places are more tolerant than others, such as where I attend church in a city 30-40 minutes away. Its in the dominant fundamentalist towns where I have encountered problems; not the cities.
Those librarians, I think, are not the norm. Most are nice, liberal/moderate, and encourage diversity. However, it still feels good to prove those former coworkers wrong. Actually, I still talk to the librarians from the area, but not at the branch I previously worked. I worked in one of the small towns I mentioned - the libraries affiliated that are 20-30 minutes away are much nicer & tolerant.