Text this: Comprehensive Review of Physics-Guided Deep Learning: Advancements, Challenges, and Perspectives