Explain the paradox of Schrödinger's Cat in the context of quantum superposition. Discuss how this thought experiment illustrates the conflict between quantum mechanics and macroscopic reality. Compare the Copenhagen interpretation with the Many-Worlds interpretation in resolving the state of the cat.