For no reason. Trans people aren't doing anything but trying to live their lives but the concept of being trans disrupts their view of the world. People fear what they don't understand and because they don't understand the real reasons for their struggles, everything they don't understand can be conflated by a confident liar saying they are related.
Possibly the most succinct summary has been sitting in pop culture for a quarter century but how it could apply to real life never clicked with most people: "Fear is the path to the dark side"
Also, that link stops with Obama and that leaves out two whole administrations that would be pretty pertinent data in this discussion. Nearly a decade of data. It looks like Trump's first term had 220 and Biden had 162. It would be interesting to see the data classified the way you described and then broken down by party over time. The actual policymaking via EO by each party over the last 50 years would be more elucidating than the straight numbers for sure.
I also wouldn't label cancel culture as "far-left" because just as it isn't in any way "liberal", it isn't limited to those on the proverbial left of the spectrum. The mainstream language used to discuss politics simply lacks the ability to reflect the nuance needed in the 21st century. And that's not even getting into the discussion on what we call "cancel culture" because there is a big gulf between "that person said a thing that was a bit off" and "that person is a literal criminal/fascist" in my opinion.
