No! You will get a payout as long as the team you backed gets the stated number of goals or points depending on the sport.
It does not matter if the opponent of the team you have backed makes a comeback or not.