I remember that quote too, and the key take aways always seemed like: in science you always learn something.

Taking the EMDrive as an example -- we have measurements that contradict current theory, so we are either going to discover new physics or we are going to learn something about the art of making very precise measurements of force in complex mechanical systems. In no case do we learn nothing.