Former QB said the most insensitive thing about an NFL legend who recently received tragic health news