The jump from PC to console has been a successful one for the Civilization franchise. The new Civilization Revolution game is substantially different from Civilization IV on the PC which itself has been very successful, and BigDownload has a full comparison of the two up. What's Civ Rev done differently?
Very small world
Half the researchable technologies.
No religion research
No in-depth civics research
More streamlined, like a god game.
Simpler controls, but no way to end turn without visiting all units.
New attack and defense stats.
More playful art style.