"We have that humble opportunity to stand with these families in very dark situations and bring a ray of hope and light into their lives," Major Dan Rooney tells PEOPLE Susan Katz Keating is a ...