Red light = standby / power error. A solid yellow light means the console is on. If your Wii stays red, follow these steps in order.
If all else fails, the motherboard may need GPU reflow or capacitor replacement. Expect $40–80 at a repair shop. Don’t force anything – the Wii’s power circuit is sensitive.