When the sand is falling, it’s not exerting force. It only exerts force when it hits the bottom. There would probably be a reduction in overall weight when the sand starts falling for a split second, and a corresponding increase as the last few grains hit the bottom. But in the middle, the weight would be more or less constant, give or take random fluctuations.