Adelaide has fought off interest from rival Australian cities to remain host of a LIV Golf tournament until at least 2028.