Molly Shannon's family tragedy shaped one of her most famous characters