I do zumba at a club and really sweat, but I don't think it, by itself, will be the only thing you need. I checked out some videos from the library and found they were not as motivating as being in a class, and were, frankly, unexciting.
[Caveat - if you have never exercised before, than it will probably help a fair amount, but I went to zumba already fit (if still a bit over weight) so zumba for M. is a fun diversion from the other cardio classes, but not the way that will help M. lose weight.]
You probably will have to do ab exercises and to reduce ab fat, you should probably decrease your consumption of white carbs and maybe carbs in general. Essentially, it won't be one thing that will do it, but a combination of things.
FYI I bought p90X and that is tons harder. I don't even do the whole thing, just pick and chose when I need to do something at home.