Yes. Halo Wars supports local multiplayer (split-screen or System Link) without an Xbox Live account.
Anyone can play locally regardless of Xbox Live status.