This is just my opinion on this subject as an Orlando resident.
Pulse was VERY frequented by people in this community gay or not. My circle usually ended up at one of the popular gay nightclubs on a night out. I am still on high alert, and I'm not sure if I ever won't be. Maybe until it happens so close to home (whether that be your city, a place you frequent, your friends, etc etc) you don't don't really grasp the terror? Calling people to make sure they're alive? We were lucky to not lose anyone, but many of our friends did.
We have not let it stop us from doing things here or abroad, but I don't buy into the "everything is wonderful!!" crap personally, because just in Orlando, for those 49 people and their families, and those with permanent injuries, I think it's pretty insensitive to insist everything is great and fine and dandy.
There's a risk in everything, yes, but I think it's worth thinking about and deciding what you're comfortable with.