The longtime couple were found dead in their New Mexico home with one of their pets