One data point does not make a point, does it? Would be an interesting survey to take all of the P5 hoops and football coaches and vote them as good role models or poor role models.
To be clear, I don't think Huggins should be fired. What he said was offensive to Catholics and gay and transgender people. But it seemed to be an off the cuff remark and he was trying to hard to be funny. He owned it right away and apologized. The cancel culture has to stop. He apologized. He can make good. He has not been a saint, but as you said, he is a basketball coach, not a spiritual leader.
This sums it up, but he will likely be canceled.