It's not the CO2 that scrubs the O2, it's the yeast that scrub the O2. So you're sort of right in that yes, the natural carbonation is a side effect of transferring during active fermentation. It is done to reduce the O2, and will give you natural carbonation
However, the other point is that canister CO2, even at 99.9% purity, is still too impure to keep below the O2 thresholds that cause staling.
Thus you solve both problems by racking while active, and carbonating naturally.
OK. I see where youre coming from now. I avoided all biology courses in college, so bear with me on this. Im still not 100% convinced its the yeast consuming the oxygen and not the resultant expelled CO2 scrubbing it out. Heres why.
Lets theorize you didnt transfer the beer and it just sat in the primary until terminal gravity was reached, and consequently no additional oxygen was introduced mid fermentation. Everything would be fine and good, and to reach terminal gravity the yeast would consume a specific amount of oxygen, nothing more and nothing less, and expel alcohol and CO2.
However, in the event that you transfer the beer mid fermentation, if oxygen is present some will be dissolved into the beer in the process. So the question is this; just because more oxygen is now available, will the yeast consume it? In other words, why would the yeast suddenly need more oxygen to chew through the same amount of remaining sugar?
Logically, I would say they dont. The yeast have a certain amount of work to do in chewing up the available sugar. That work will require a specific amount of oxygen and will produce a corresponding amount of CO2 and alcohol. After all, thats how were able to bottle carbonate without blowing up our bottles. But, as I said, I avoided all biology and have no basis for this other than what seems logical to me.
Last thing. If carbonating with the canister results in more mols of oxygen being exposed to the beer, then I agree it will result in more oxygen going into solution. I can see how forced carbonation carries oxygen with the CO2. What this means, though, is that your beer will inevitably become more and more oxidized as you dispense the beer. The amount of CO2 to dispense a full keg of beer at 12 psig is about 60% of what it takes to carbonate that same beer to 3 volumes.