Offering an alternative and mostly unpopular view, there are lot of things that society should spend that may not always have a great financial return on investment but will contribute to the culture of society (sports, art, entertainment, history, etc).

That said I do think the Commonwealth Games is a massive cost sink during poor financial conditions and sports already gets a disproportionate amount of funding compared to the others so I don’t think this is necessarily a bad move!