Why should it not be possible to solve this with statistical methods? The model just needs to be able to understand the important meaning of "no" in here, in the context of the whole sentence. I would guess that most modern NNs from the NLP area (Transformer or LSTM) would be able to correctly differentiate the meaning. The problem is, I think there is no fancy NN (yet) behind Google search, and the other web searches.
To extend on that, you can think of the human brain as just another (powerful) statistical model.
To extend on that, you can think of the human brain as just another (powerful) statistical model.