Sweeney is facing backlash from female athletes over her new ad for sports trading app Novig