When Geoscience Meets Generative AI and Large Language Models: Foundations, Trends, and Future Challenges