I've tried it and it always does something else, like start an unrelated playlist or playing all music or says "HomePod can't do that..."
Supposedly, you just need to say something like, "Hey Siri, play the song that goes 'I don't support the team.'"
When I do that on my HomePod it says, "Playing all songs, shuffled."
Which, in some perverted way could be considered correct (I guess, if you waited long enough). However, that lyric is from P!nk's "Don't Let Me Get Me" that I purchased on iTunes a year or two ago (and which shows up for streaming on my iOS devices and is even in one of my playlists).
However, I don't have an Apple Music subscription, so I guess that is an absolute requirement (it can't be a song that you merely PURCHASED from iTunes).
I’ve had a complaint open since March... “Engineers are working, No ETA”. In other words, we haven’t paid the royalties required and this feature is disabled. Bet it’s the same for new lyric search ability.