A Survey of Sim-to-Real Methods in RL: Progress, Prospects and Challenges with Foundation Models