Explain the paradox of Schrödinger's cat within the context of quantum superposition. Discuss the theoretical concept of decoherence and how it attempts to resolve the measurement problem by explaining the transition from quantum superpositions to classical outcomes without the need for a conscious observer.