I know how to use CC sphere to make the earth from the map. But I'm wondering how to animate the transformation.
You will need to use a different plug-in. Conoa Sphere, Borris FX.... There are lots. CC Sphere will not do this transition.