Although the German Expressionist was undoubtedly depressed, new evidence suggests that the artist could not have fired the gun that killed him in 1938 himself