If you plug your DSL/cable modem directly into the AppleTV's ethernet port, it will not be able to share the connection with other computers in your house.
I'm doing OK with manually plugging a USB drive into my MBP once or twice a month for Time Machine to do its thing, but if it did it automatically via wireless, that'd be awesome.