Should I be concerned that the fan on my 11 inch Air makes a lot of noise when I play Call of Duty Black Ops?
No, it will shut itself down in the fairly unlikely event that it gets hot enough to risk causing damage. It's designed to run hot with the fan at high speed when it's under high CPU load.