If I want to deodorize my carpet with baking soda, should I spray water on the baking soda?
Baking soda needs to be in contact with the odors to work.  If the baking soda is wet, it will not really work at all because the water will be blocking the odors from getting near the surface of the baking soda.  I also suspect it would be a real mess to clean up.  

In the past I've tried baking soda on carpets (dry!) and found it to be a waste of time.  A professional steam cleaning is probably the most effective solution.