What are the effects of successful or unsuccessful season missions?

If you succeed, you will be more likely to get playing time, and your annual salary will be revised for next year.
There are no particular disadvantages even if you fail.