On the Opportunities of (Re)-Exploring Atmospheric Science by Foundation Models: A Case Study