Thousands of people went to watch the massive bonfire burn as fireworks filled the night sky