The simple answer is yes. If you get a ride on a team bike, the multiple sponsors of that team will pay you more than you could earn with the best sponsor of an Rookie bike.
If you really want to bank coin, race as your favorite rider. This is the best way to earn as much coin as possible and upgrade your team to earn even more coin. You will also get to compete in the Fan World Championship when you race as your favorite rider.