The Great Filter Mystery: Unveiling Cosmic Challenges to Intelligent Life