Thanks to a $30 million revamp that rethinks the experience, seeing the pyramids is finally inspiring more awe than agony.