On the Foundations of Earth and Climate Foundation Models