Towards Scientific Discovery with Generative AI: Progress, Opportunities, and Challenges