iDVD will work with non-Superdrives, but not in a way that will be useful for you.
According to Apple's page for
iLife , you create iDVD projects with a non-SuperDrive, but you need a SuperDrive to burn projects.
Perhaps you could use iDVD with an external DVD burner in conjunction with Toast 6 to produce slick DVDs.