Former star quarterback shares his struggle with addiction and newly found gratefulness in life