If you are a fanboi it is the actual second coming. If you are any normal person, it is a marginal speed bump. It might be a battery life bump too. To answer the poor folks who need a computer now but wonder if they should wait, nope. Sorry, this will likely take 2-3 months to arrive in an actual MacBookPro, maybe more.
The bigger issue right now is OS stability. I would buy a Mac I can run 10.4.11 on if I want to, as well as 10.5.8 (not 10.6).
One big advantage to 10.4.11 is pretty much any person running an environment of software and settings can migrate seamlessly to much faster Intel hardware if it runs 10.4.11. Then when 10.6.5 becomes stable, you can DECIDE whether to upgrade.
One of the things Apple does which is pretty hard on users is to simply suggest they adopt every software update. I think they should suggest that for developers and bleeding edge adopters, but should warn luddites, grandmas and late adopters to stay old and stable for a while.
Maybe MacRumors needs to do a how-to for making a partition and OS install and switch lesson so folks can switch to reliable when needed and to "new and cool" when feeling brave.
Rocketman