Sigourney Weaver has admitted she's keeping her hope of grandkids 'in check' because her only child is 'ambivalent' about having kids