Bridging AI and Science: Implications from a Large-Scale Literature Analysis of AI4Science