Just tested, typical Scotchgard, water will bead right off untouched, but as soon as you rub your finger over the trousers, the water will start to wet out the fabric, so walking in them while wet with the material rubbing together, or sitting/kneeling, will cause the water to soak through.
So...