You might say this sign is normative, but definitely not heteronormative. This is a church on P Street in Washington, DC.
Actually, is this a normative sign? I usually think of normative signs as giving categorical instructions: “Do this,” or “Don’t do that.” Thus a bumper sticker or political slogan isn’t a normative sign in the relevant sense (i.e., the sense this blog is interested in) because it doesn’t offer specific instructions, but merely implies support for a point of view. In a way, the sign pictured here is in a way more like a Welcome matt. But the rainbow implies not just an expression of solidarity, but also a kind of targeted invitation: “You — yes you — should come worship here.”
(Thanks to Wayne for the pic.)