A Survey on Diffusion Models for Time Series and Spatio-Temporal Data