Gene Hackman and his wife Betsy Arakawa were found dead at their New Mexico home by a caretaker, who made a frantic 911 call to emergency services reporting the tragic discovery