The second boiler at a former coal-fired power station has been demolished in a spectacular explosion as the energy precinct makes way for a cleaner future.