Fireball, lacking a "pressure wave" is not really the optimal spell for wrecking a room, instantly, though the fires started by it will ensure that in the immediate future ... maybe less of a problem in dungeons, but in an average medieval to renaissance room, especially one with drapes, hangings, carpets, sawdust or shavings on the floor, plaster-daubed wicker walls with wooden frameworks....not to mention lamps etc. shattered by the explosion and releasing their igniting fuel into the room... I am not even going to mention smoke caused by the fires. The initial damage from the spread will be the least of their difficulties within a few rounds.
Demonstrate the problems caused by 'fireballing' indoors to the players prior to the final encounter - they will likely take the hint.
Now, if you want to wreck and cave-in a room, use "Shatterfloor" (MoF or SC), it is basically a wrecking ball against structures, sonic damage not being halved when determining damage to objects.... Or "Acid Breath" (SC) etc...
As for supporting pillars and beams - take into account that these need a mininum level of integrity before they collapse from stress - after all you cannot hold up a ceiling with a beam with the remaining Hit Points of a reed...*grin*