This page demonstrates using jQuery and some simple styling changes to do a simple animation, like the one you see on my home page.
This type of jQuery-based animation is nice because it is far more cross-platform than something like Flash. Try it: look at this page on your iPhone!
No, jQuery animation can't replace real, full-featured animation like something like Flash offers, but for something simple like this, it works really well.