You can't transfer apps from CD/DVD to install on the iPad. You can only install apps from the App Store. If there happens to be apps from Rosetta Stone in the app store, that's the only way you can get it, but it most likely not be the same as the CD/DVD version.
There is an online version of Rosetta Stone that you might try. My guess is that it won't work either, because it probably uses Flash or something else not supported. You might want to check it out anyway, though, just to see if you get lucky.