motorsport racing like Danny Ric that had to be paid for the remainder of his contract despite being absolutely atrocious and the team not wanting to have him take up a seat? Seems like just another sport where deals are being more guaranteed and longer with less performance bonuses required.

NFL is moving towards more players getting guaranteed contracts. NHL already has guaranteed contracts up to 8 years in length and next to no performance bonuses. Similar with the NBA. So this is just more of an example of yes sports are moving in that direction with some already there.
LIV also isn't likely going to be dishing out 5+ year contracts to everyone. A lot of the initial deals are based on the risk that the league fails.

Okay which other sports are players paid based on their weekly results?

Isn't that how most sports are though. Wins are personal goals and the financial benefit usually comes in your next contract. NHL has basically no money for star players for the playoffs but clearly winning the cup is meaningful.

Strangely it sounds like the lights are still operating