IMHO, this would make the games all the more immersive. Can you imagine playing during a thunderstorm and having thunder rolling outside and inside your house? Or a sunny say inside and out? Or simply an afternoon rain?
The only downside is that the Wii updates weather only a couple times a day which would tend to give you a rather large time slice of the same weather.