No it’s really not.

Recommend doing a bit of real traveling. As far as things go on a global scale a lot more FUD comes out of the US because it is an absolute media machine and everyone has their eyes glued on it at all times. As far as real world acceptance of LGBT it doesn’t get much better anywhere globally than California. In my experience other than perhaps, some select parts of Western Europe, the comfort level for LGBT travelers is much higher in the US than most places. There are cesspools like Florida that stand out, but this travel warning is largely propaganda.