The Titan Pack will be available for PC and PS3, but Xbox 360 gamers won't receive the new content. BluesNews claim that this is due to download limitations on Microsoft's console.
You can check out all of the major new features here, which includes 16 new maps, two new weapons, two new characters and significant A.I. enhancements.
It might even be worth playing now.