Compressing it with handbrake will probably not look worse. MPEG2 used in DVD is notoriously inefficient by today's standards. Depending on the codec selected, it'll be a fraction of the size with no visible differences.
Unless you mean to keep the DVD structure and playability in DVD players (including menus and everything), but I don't think handbrake can do that.