i believe they only suspected that holy might kill everybody but didn't really know. it takes out everything that is a danger to the planet apparently so it makes its choice.
perhaps at the end of ff7 they intended to suggest that humans had died but red xiii types had lived on or something and then changed their minds for advent children.
whatever happened midgar certainly wasn't too pleased about it by the looks.