Young children and a pregnant woman were killed by a grandfather in a horror shooting that left nine dead, with the community "heartbroken" by the "devastating loss"