That stored oil would burn one way or another, emitting the same CO2. Unplanned spontaneous disassembly by "falling drone debris" just accelerates the process a tiny bit. It does look much more spectacular though!

You are just looking at current event (a massive refinery and oil storage fire) and not the longer term picture. By that petrochemical complex burning down (arguably in quite a dirty manner) much more oil than has burned will not move through it, contributicontributing to CO2 emissions, pollution and war funding.