Is it also a problem to do work for a religious Web site? A pro-gay rights site? An anti-gay rights site?

There's always someone somewhere who's going to take issue with who you work for or what you do.

It's problem to the extent that just living your life as you chose and believing what you chose to believe are problems.

I.e., that's life.