The son of sports reporter Christina Chambers led his grandfather to the dead bodies of his parents after they were killed at their home in Hoover, Alabama