A planned Olympic drone show in Brisbane this weekend has been cancelled, after a disastrous display before a Matildas match in Melbourne saw 350 drones falling into the Yarra River.