Text this: When Remote Sensing Meets Foundation Model: A Survey and Beyond