I wouldn't say it becomes useless without wifi but definitely less useful. The timeline cards are saved to glass memory, so the content on them should theoretically be accessible without wifi.. I am under the impression that any actions performed without a connection get queued up, and then sent once connected, though I'm not perfectly certain that this is the case..
Twitter on steroids is actually a surprisingly accurate analogy, I think. Probably just about the most accurate description I've heard so far. Mostly I think people think of google glass as a HUD, which it isn't.. yet anyhow.