Technically, I would say that anything you enjoy that gets you moving is always a good thing.
However, the idea of a weighted hula hoop sounds silly to me. You cannot spot reduce fat, so if it's claiming you'll loose inches from your stomach by swinging your hips around, it's a flat out lie.
Nonames had the right idea. Save your money and just buy a regular Hula Hoop instead.