There is nothing in the books itself that is anti trans (AFAIK and remember), it is that people equate her works with her political views which are anti trans. As a most likely trans person myself (still working out the details of it, stay tuned) I have a real struggle at my hands. On the one hand her books were a massive part of my childhood and early teens. I waited in line out side book stores to get the newest one. On the other hand she uses the money she gets from licenses and the IP to fund anti trans organisations. She also uses her fame / reach to spread TERF points of view. I enjoy and love the world she created back then but I cannot in good conscience consume anything that supports her now. Not any merch, series, film or game.
I on my ow may not make a difference but the sum is more than it parts. If enough ppl. start voicing their objection to her and her views, boycott the new stuff because of her, some change might be possible. If not, sacrificing something I loved growing up is an acceptable price to pay to keep me and others safe.
While sex is in it it was never the focus of it imho. I love the series but I do think ppl. do somewhat overstate the amount of sex that is happening. Sure it gets to be a tad bit more frequent in the later books but is not the main focus. The world building is amazing and the story is fantastic. So even if you are not too into the whole sex/romance stuff you ca enjoy the series.