Apparently Steam is just a CoD retailer. If one wants to use Steam for online play then I would imagine one would need a Steam Account, but since Steam isn't responsible for the DRM of CoD then an account wouldn't be needed otherwise. Updates/add-ons may also be available through Steam for those who have such an account, otherwise it's the old update/add-on method we're
all accustomed to.