It refers to the phrase "walk the straight and narrow path," which comes from the Bible and refers to the road to salvation and virtue (meaning that it's not easy to be a good person).
So "straight but not narrow" is a play-on words, meaning that while they're straight (i.e., heterosexual)., they're not narrow-minded about homosexuality.