Haven't tried the "name this song" feature myself
as my phone is likely too old to handle such things (and I've NEVER used the Google assistant!), but could it be that it misheard the "na na na na" sounds as words and couldn't identify them? What if you tried again by humming instead? Still definitely a failure, but possibly not as bad as it looks.
And if I know some of the words, I can DuckDuckGo them (see what I did there?) and find the name of the song myself!