North Carolina football coach makes a highly offensive video, gets fired