Devastating new photos have revealed the horrific state that Gene Hackman and his wife Betsy lived in before their tragic deaths in February