The attorney general suing Harvey Weinstein has resigned following his own abuse allegations