Fred is right, any change is virtually nothing, certainly not noticeable to anything but very finely tuned instruments.
But lets look at the Chemical Process.
$\ce{CH4}$ (mined from the ground) + $\ce{2O2 -> CO2 + 2 H2O}$. The $\ce{H2O}$ while it enters the air as water vapor doesn't stay water vapor for any significant time so the Atmospheric scale tells us $\ce{2 O2}$ to start (64 atomic weight), $\ce{CO2}$ out (44 atomic weight), so burning methane lightens the atmosphere.
Now, lets look at gasoline, which is a variety of hydrocarbons, but lets say Pentane is the most abundant one (not sure it is, but it might be) $\ce{C5H12}$, here we get the following:
$$\ce{C5H12 + 8 O2 -> 5CO2 + 6H2O}$$. With this one we have 256 atomic weight to start and 220 atomic weight to finish.
As the carbon to hydrogen ratio goes up, the mass of the gas after the fuel is burned goes up, but on average, because burning fossil fuel takes oxygen and makes water as well as $\ce{CO2}$, mostly you're losing mass in the atmosphere and gaining water - but in negligible amounts.
There are other, larger factors, which, I don't understand all that well, but oceanic absorption for example. Oceans absorb atmosphere (less as they get warmer) so as the Earth warms the oceans will store less air and the atmosphere will gain in mass, a bit. Similarly, warmer air holds more water vapor, so, while burning $\ce{CO2}$ takes a little bit of mass out of the atmosphere, the warming will have the reverse effect. More water vapor will be in the air and less air will be in the water.
A 3rd effect, photosynthesis for example takes in $\ce{CO2}$ and puts out $\ce{O2}$, so as plants grow, the mass of the atmosphere is reduced, but overall, plants are simply not growing fast enough to match our output of $\ce{CO2}$. Not close. But the respiration of animals and plants on the planet does play a role, but as near as I can figure, the mathematics of this is pretty simple. Plants take in $\ce{CO2}$ and release $\ce{O2}$, animals, by eating plants, do the reverse, we breath in $\ce{O2}$ and exhale $\ce{CO2}$, so any net change due to animal life would probably register in total $\ce{CO2}$. (I think).
So there's your answer. The burning of the fuels makes the atmosphere a teeny tiny bit lighter but the warming of the atmosphere makes the atmosphere heavier and that's likely the trump ward. A warmer earth has a heavier atmosphere.
About 0.25 of the mass of the atmosphere at any given time is water vapor (Source), compared to about 400 PPM $\ce{CO2}$ or 0.04% by volume, but since $\ce{CO2}$ is about 50% heavier than the oxygen/nitrogen combination, about 0.06% by mass.
Because $\ce{CO2}$ isn't just added, but oxygen is taken away in greater mass when burning fossil fuels (44 to 64 with methane, 220 to 250 with pentane), it's tough to estimate but lets say about 15% of the mass of the increase in $\ce{CO2}$ is taken out of the atmosphere due to loss of $\ce{O2}$.
The increase in $\ce{CO2}$, from 280 PPM to 400 PPM, is 40%, so working out the math, 0.06% * 0.4* 0.15 = rough estimate 0.0036% of the mass of the atmosphere lost due to all our fossil fuel burning since the industrial revolution.
But, just 1 degree of warming can increase the atmospheric $\ce{H2O}$ by 6%-7%, so if we figure about .8 degrees C of warming this century and we run the math on atmospheric water vapor 0.25% * 0.06 * 0.8 = 0.012, or over 3 times as much mass added to the atmosphere from warming as is lost in fuel burning. And that doesn't take into account oceanic absorption, which as the oceans warm they hold less oxygen. Similarly, as Tundra thaws, gas is released from the Earth.
The net change (while quite small) is likely a heavier atmosphere (about 1/100th of 1% (so far, and more to come), but that's 1/10th of a millibar. A typical High to low pressure variation at sea level is about 30 millibars (Source), so we are talking about an unnoticeable change.
My math is rough but I think that's the correct answer to your question. You can't just weigh the $\ce{CO2}$ added, you have to also weigh the $\ce{O2}$ taken out and the bigger factors, atmospheric $\ce{H2O}$ and Oceanic absorption of atmospheric gas.