“Team Spirit”, by Robert Wyatt (from the album “Ruth is Stranger than Richard”), is a song actually sung from the POV of a football. (Or “soccer ball” if you’re American.)
“Black Superman,” a hit song in the Seventies for Johnny Wakelin, was a tribute to Muhammad Ali.
“Big Leagues” by Tom Cochrane and Red Rider was about a teenage baseball star whose dream of a pro baseball career were ended by an automobile accident.
Since Clothahump already mentioned Kung Foo Fighting I’ll offer another '70s favorite, Black Superman ,about Mahammad Ali (he floats like a butterfly and stings like a bee).
This is the most motivating song I have ever heard. If ever I don’t feel like going for a run, all I have to do is hear the first note of this song and I know I have no choice but to get off my lazy a$$ and out the door.
Journey’s “What it takes to win” is another motivator although I’m not sure it’s specific to one particular sport. Just a great song.
Then put on the entire discography of Two-Man Advantage.
The Distance by Cake is about a race car driver.
“I Think I Can Beat Mike Tyson,” The Fresh Prince and D.J. Jazzy Jeff.