I found the attached image when I searched this. From your description and the red banner on the app page I would say that they have either stopped supporting the app or they are working on something else, maybe to bring the app back and make it better, maybe? Anyway, you can write to the app developer and see if they are answering questions about the app, which if they have stopped supporting it they may not answer but for definitive answers, vs. wild speculation, OK not so wild, they are going to be your best source for information.
Are you asking about an actual app on the Play Store, or the Google Weather shortcut you can add to the homescreen if you use the main Google app to search for "weather"? I still get the frog every time when I use that shortcut on my Pixel 6 Pro. Be aware, though, that it doesn't seem to work on certain kinds of tablets (at least not right now).