I have a pixel 8 pro on Android 14 and have similar issues with the widgets. I think the recent update to the Nov security patch may have broken something. At least that seems to be around the time my windy widgets quit working.
Edit: I just added my widgets and they are working normally at the moment. Hopefully this will stick.