Advantage:
You could fire things such as flaming stones, cattle or even plague victims over the walls of a castle at a safe distance. The catapult was best used with a siege.
Disadvantage:
The catapults wasn't very accurate and as you were preparing the catapults, you could be fired at and had a better chance of dying.