Interestingly Microsoft are investigating a 2020 Live Weather bug reported here: Online Services Monitoring
I do wonder if the resolution for this is affecting the weather services for MSFS 2024 as well. Hopefully this is just temporary and it will be working soon.