Leslie Moonves has resigned as CEO of U.S. media giant CBS over sexual misconduct accusations from six more women