"I remember going out to my truck in the middle of practice and meetings overcome with grief and emotion," said the retired NFL player