A nine-year-old boy has died after spending over a week in a coma following the crowd surge at Astroworld Festival.