Sensing, Social, and Motion Intelligence in Embodied Navigation: A Comprehensive Survey