Google Clock now lets you open local forecasts, but there's a catch

You need the Pixel 9 Weather app

https://www.androidpolice.com/google-clock-pixel-weather-local-forecasts/