The San Francisco 49ers cornerback created a furor by saying he would not accept a gay teammate