1 CPL + 1 CPL you would get retarded colour patterns. 1 LPL + 1 CPL or 1 LPL + 1 LPL will give you a variable ND filter from about 2 stops to completely black (well ideally anyway).
The light coming out of the back of a CPL is circularly polarised meaning that any effect caused by polarisation of the sky or ground has been altered. Put another polariser on it and you'll show cool patterns.
Light out of the back of a LPL is linearly polarised. Put another polariser behind it with the same angle and you just lose 1 extra stop of light due to the filter. But rotate that second filter 90deg from the first and you effectively cut off all light.
:Lol: it has nothing to do with quantum mechanics, it's electromagnetics