This indirect energy output is small in comparison to the reactor's output, but a small percentage times a very large power output is still sufficient to meltdown a reactor (and boil away the coolant in the process) if there's no way to remove the heat being generated.
Imagine what you'd have to do with a car engine if every car trip of 4 hours or more produced 4% power output in the form of heat for the next day after your trip was over.
In Chernobyl the core literally blew up, so it's a different situation. But in Fukushima the pumps lost power and so even though the control rods were fully inserted, there was a real risk it might get hot enough to melt down anyway. That was thankfully avoided.
TL;DR: the control rods slow the reaction, but the fuel rods are still hot, and the space is enclosed (to prevent radioactive material from casually escaping) so it gets hotter and hotter without intervention. If the fuel rods get hot enough they start melting, which produces hydrogen, which can explode.