Yes, I have a Pixel 3 and can confirm that the feature is off by default; I turned it on for a while to experiment and then turned it off again. Also, it appears that if you turn it on, it compares what it hears against a much smaller set of popular songs (probably comparing against a set of feature vectors that's already on the phone); the search for anything obscure tends to work only if the Google Assistant is used.