MSN Weather, like all of those MSN app, are actually pretty cool little offerings--they're Metro, minimalist and do what they're suppose to do. In 2010, MSN Weather was for many their first weather app. Not much has happened though in terms of updates, which is a shame since Mango offers a lot e.g. Live Tiles.
That's why we became a little excited to see an image of an updated version that is coming down the road. In the above screenshot from Microsoft's Jeff Wilcox (of 4th & Mayor fame), we see that it finally now has that Live Tile with the current temperature, making this app very useful for many and a good free alternative. No other details are known currently but the app is being beta tested meaning release in probably only a few weeks away.
It's great to see Microsoft finally updating some of these apps though we think it would have looked better 4 months ago.
Update: Regarding Jeff's grey theme, there's no shenanigans there. That is simply one of the theme's on his unlocked Lumia 800 purchased through Expansys. While that's a great theme, he did lose out by not having the "Nokia Blue" accent color.