No. Undead Nightmare on Xbox 360 requires an active Xbox Live connection to launch, even for single-player.
If your internet is unreliable, the disc version of the main game is fully playable offline; only the Undead Nightmare expansion is locked.