When you start working in the realm of macro, magnification becomes the primary consideration.
If you want to have that half inch long insect fill up a half inch long image on your negative, you need a lens and system that will give you 1:1 (life size) magnification.
To achieve that, if you are using an unmodified* lens, you need a lens and camera combination that permits moving the lens' nodal point to a distance from the film plane that is twice the focal length of the lens.
That movement of the nodal point will focus the lens at a particular point. The distance that that plane is from the nodal point is a function of the focal length of the lens - a 100mm lens will focus to life size magnification at a distance that is farther away than a 50mm will focus to life size magnification.
What would the advantage of a 50mm macro lens be compared to a 100mm macro lens? Potential lower cost, smaller size when focused at more normal distances and, in some cases a closer working distance (when the desired perspective that arises therefrom is sought).
*I make reference to an unmodified lens, because one of the ways of achieving higher magnifications is to "modify" it - insert higher magnification into the system optically. You can do that if you either add close-up (diopter) filters at the front, or tele-converter elements at the back. When you do that, you can achieve more magnification without reducing your working distance as much.