A popular firework display, which was cancelled last year due to bad weather, has been axed.