OK,
Consoles are power interactions that adjust ship systems / functions. Plasma streams run through the odm conduits to the terminal displays (via small plasma conduits. You will see them when a terminal panel is popped up or off.). You bet your ars that the plasma can explode or even eject jets of energy from the terminal if damaged a certain ways.
You see, terminals have many different ways they can be damaged. They don't always explode. Enough said.
No sir.
Each ship systems is specific. Each terminal is specific to each system. Many back up and fail safe systems involved, but during combat, overloads and ODM plasma conduits to terminals often get damaged. Remember, the terminals channel / direct streams of plasma directly. Hard to put a circuit breaker on that sir.
These aren't early 20th century machines, directly handling giant currents like an electromechanical computer running an elevator. They're mildly modern style systems sending signals to power handling equipment, keeping things isolated.
Considering everything gets back to main computer this, main computer that, the implication is the consoles don't need to be powerful, they only need enough to run their operating system, and can push all the hard stuff on the super computer. We also know the consoles are not hard coded, single function computers, the rear consoles make that abundantly clear. The have been used for data correlation, damage control, take over of the main computer, and the big one is, engineering control. Even the way warp works shows the bridge doesn't use a direct loop in the warp drive, because they're frequently calling down to engineering for more speed and more power, like a steam ship, rather than a ship with an internal combustion engine. Same for the school room computers, which once given LCARS access allowed Picard to gain control of the transporters, a very high power system, from inside the school room. That shows control of systems aren't done with one to one connections, so console overload based on specific system overload doesn't make sense.
Consoles have no business using as much power as a a whole laptop battery every second, let alone requiring taps into the main power trunk. The explosions from console are also inconsistent with plasma explosions and leads stated to actually be plasma based.
