Stanby means WiiConnect24 is on. And the light will be yellowish/orange. Your Wii cannot be harmed by the WiiConnect24. If you have a faulty heatsink, your GPU will fry eventually, whether you leave the system on Standby or not.
If the light on your Wii is Red, that means it's completely off.