Former American football player who was acquitted of murder in 1995 died of cancer, according to a statement by his family