I did the same on my late 2011 MacBook Pro 15'.
Many people say the enlightening process is not relevant, but it's wrong.
I'll give you my exact numbers:
MBP: 2555 g.
Super Drive: 127 g.
Stock Toshiba HD 500Gb: 103.5 g.
SanDisk Ultra II 240 Gb SSD: 36 g.
-------- Super Drive removed, and HD replaced with the SSD ----------
Final weight: 2360 g. (92% of the original weight)
Total reduction: 195 g. (8% lighter)
The most will depend on your SSD's weight but they are generally very light.
Not bad, considering the latest Retina MacBook Pro 2015 weighs 2040 g. (after 4 years of progress).
Note: I did not count the 3 screws I removed and the Super Drive connector (sort of a rubber cap).
As you can see, doing this operation is relevant, I personally feel the difference when I carry it around. Another big advantage of removing the Superdrive is getting rid of that annoying mechanical noise at startup, and allowing more internal volume for air circulation. Thanks to the SSD, when the fans are not spinning you will have a 100% silent machine.
If you really can't live without burning DvDs (I doubt so) you can get a $15 USB enclosure for the Superdrive you dismounted and make it external.