It does though, the reason it's relatable as a joke is that it's a somewhat common scenario. It's not that people sniff milk when it's bad, they do so to determine if it's bad, and that's usually done in a circumstance where you need milk and only realised that the milk you have and need now might actually be suspect and should be checked. It's also one of the few foods where such a test is fairly accurate and the risks of illness are pretty low which is likely why it's a fairly common thing that people do.
It does though, the reason it's relatable as a joke is that it's a somewhat common scenario. It's not that people sniff milk when it's bad, they do so to determine if it's bad, and that's usually done in a circumstance where you need milk and only realised that the milk you have and need now might actually be suspect and should be checked. It's also one of the few foods where such a test is fairly accurate and the risks of illness are pretty low which is likely why it's a fairly common thing that people do.