Rowling, a vocal supporter of women's sex-based rights, has long been targeted by transgender activists for her stance that biological sex is real and relevant in law and society