Normal is much safer, less likely to go wrong, and still likely to give a decent upgrade. Aggressive has more potential for a larger improvement, but also more likely to go wrong (as Jean already pointed out). And Conservative is almost certainly going to be an improvement, but only a small improvement.
That's how I understand it to work. I went Normal for things last season, but now this season since I was at the back of the field I went with Aggressive, because if it went wrong I could hardly go any worse than I was.