There are too many to count:
Garth Brooks, "Standing outside the Fire" (about "retarded" or special ed people specifically, and anyone who has been an "outsider" generally).
Garth Brooks, "The Dance" (about accepting the pain that inevitably comes with loving, sometimes, especially when you're younger and naive).
Lone Star, "I'm Already There" (literal song about a person who loves you, who is physically distant, but in spiritually has always been next to you).
Madonna, "Masterpiece" (about realizing that nothing, no matter how beautiful, can last forever, even love).
Josh Groban, "You Raise Me Up" (very literal and overtly religious, but one of my late grandmother's favorite songs).
Luther Vandross, "Dance With my Father" (very literal and schmaltzy, but addressing the pain of losing a father at a younger age and how often you feel more sorry for your widow mother than yourself).
Righteous Brothers, "Unchained Melody" (a bit literal, but simply beautiful melodically and in feeling).
Jewel, "Foolish Games" (personal pick, a song I bonded with when I was 15, had my first crush on a guy, and I'd stare at his picture and listen to this song and feel the cognitive dissonance and pain of desire for him versus what I was "supposed" to love and be).
Andrea Bocelli, "Vivo Per Lei" (in the foreign language a bit literal, but always melodically beautiful and better in the foreign language version than the English version).
Judy Garland, "Somewhere Over the Rainbow" (dated, but timeless, and forever reminding us that it is okay to dream and long for more peace, love, and contentment).
Henry Mancini, "Moon River" (watch Breakfast at Tiffany's)
Roberta Flack, "The First Time I Ever Saw Your Face" (elegant, classy, storybook).
There are so many more, I have to stop.