Warner Bros. CEO resigns over sex scandal