If it's the same as the PC version, then yes, you can play single player with bots, but BF2 is made for online multiplayer. Don't bother if you're not going to get LIVE.
BF2's single player mode is only for training purposes. Period. It is nowhere as fun as the real thing and it is mostly there because it's a complex game and going online with it without any kind of experience leads to lots of pain, sorrow and pwnage.