I suppose it may make different sense depending on the context, but the expression is often used as an example of celebration, of joy for something. The rockets in this case are pyrotechnics.
* Only one "like" per meaning and day, the more "likes" the meaning will appear higher in the list