Polarisers have special grain patterns (IIRC) that controls how light rays impacting at various angles pass through it. By rotating it you change the orientation of the grain patterns, and how the different light rays pass through it.
best way to view the effect of cir pol on photo is to point it at reflected light from sea / water / glass when u turn the filter u will c the glare reducing