Sabrina Carpenter divided fans as she advocated for trans rights while performing her new explicit single Tears at Sunday night's MTV Video Music Awards