> It is sad because this is how science is meant to work

No, it is not meant to work that way.

The situation were formed by pretty predictable and easy to model factors, and if the science have failed even with that, how can we right now trust it with the things that are obviously way harder to predict?