A prime lens is a lens with no zoom function. It has a fixed focal lenth, in the case of my lens - 50mm. These prime lenses often allow you to set your aperture to a large range of values. My lens allows me to set the aperture between F/1.8 and F/22.
The lower the F value the more light is let in. However, the lower the F value the smaller the range of focus, so if you were to focus on something at F/1.8 that object would be in focus, but the background wouldn't be. If you were to focus on the same object at F/22 the background would be in focus. If you were to take a macro shot at F/1.8 with extension tubes the range of focus would be tiny. This is why you need a prime lens, so that you can set the F value very high.
At very high F values you will require a lot of light. Also, the further you extend the lens out with extension tubes, the more light you will need too. This is why you need a flash for short exposure shots. You could also do long exposure shots with a less bright light source - like a torch for example.
Hope that helps.