Do I need to play all game modes in Weekend Series to get rewards?

No, you can play specific game modes if you want to but it will be harder to compete for the overall standing in the Season.