After all the AFL's were refitted when one blew up in 2005.
It was one of the pyros that went off while it was still in the tube. And it was one of the two shots located on the Inferno Barge.
The Inferno Barge was out of commission for quite a while, as it needed extensive repairs. (I think they ended up just replacing all of the gas and electric lines on it to be safe) The incident happened in Sept 2005, and the barge didn't return until early Feb 2006.
During that time, the UK's launcher was also taken out of commission, and instead an additional comet was shot from the seawall launcher closest to the Rose & Crown. But it was the same pyro that is shot off from the seawall during the Celebration segment, so the effect wasn't the same. (It was really very poor, actually)
(And for those who were wondering, the UK ALF launcher was located in the same row of buildings as the Tea Caddy, but at the opposite end of that L-shaped row of buildings.)
I think even after the inferno barge returned, it was a while before the air-launchers returned to the show. (There's a video on YouTube posted March '07 labeled as the "new" air-launched comet) They moved the dual launcher off of the inferno barge and onto the boat slip/dock in the middle of the Lagoon (so that if another incident happened, it wouldn't cause as much damage) , and they relocated the comet launcher to the American Gardens theater. (The Lagoon-based launchers may have been re-introduced first, while still using the seawall-based comet)
The move for the comet was because they decided that they wanted to eliminate launching the comet over a Guest area. Because of the UK's launcher position (which was chosen because it gave the best arc over the water), the live pyro was shot off over the Promenade walkway and the Rose & Crown. Every night CMs would have to close the Promenade to foot traffic for a couple minutes right before the show until after the comet had successfully fired. The new location eliminates that.
-Rob