When the light is red, the console is off. When the light is yellow, that means you need to disable WiiConnect24 in the settings.
Also, everyone who has WiiConnect24 running when their Wii is off should turn it off. It's causing problems in some people's consoles, so if you want to risk...