The Evolving Landscape of AI for Science and Engineering: Bridging Simulation, Experiment, and Multi-scale Dynamics