Now that I have Resistance, will I automatically see pistols in old missions and campaigns?

No. OFP: Resistance has new soldier unit names, such as "Officer (HandGun)" and "SpetzNatz (HandGun)", that have pistols. These unit names were not available for use in earlier missions and campaigns.

Of course, you're perfectly free to editing the old stuff and toss in the new.