The X.Org 7.5 Super Module is simply a Git repository that contains all of the latest X packages going into X11R7.5. Among the many packages are X Server 1.7, xf86-video-intel 18.104.22.1681, xf86-video-nv 2.1.15, xf86-video-ati 6.12.4, and libdrm 2.4.13. Many old and obsoleted packages have also been removed from X.Org 7.5.
Look for X.Org 7.5 with its Multi-Pointer X support and other new features and fixes to arrive later this month. However, outside of Fedora 12, most desktop Linux distributions will not be pulling these new packages into their stable releases until their 2010 updates.