You do not necessarily need a mattress pad on your bed, but it adds an extra level of comfort whilst also protecting your mattress from sweat and body oils. It's also a lot easier to take off and clean than cleaning the mattress itself.
A mattress pad goes on top of the mattress and under the bottom sheet.