Since an explosion describes a kind of uncontrolled combustion and CO2 isn`t combustable - it can`t explode.
So lets assume you mean burst due to temperature or pressure extremes. Due to its design (the end you pierce is the weakest part of the cylinder) the worst that could possibly happen is the cylinder could vent through that end. But I`ve never had or heard of that happening myself.