Cantor's Continuum Hypothesis: consequences in mathematics and its foundations