Compare and contrast the Copenhagen Interpretation, the Many-Worlds Interpretation, and Pilot Wave Theory regarding the 'Measurement Problem.' Discuss the theoretical trade-offs between locality, determinism, and wavefunction realism in these frameworks.