It was a popular destination for families from across the UK for more than five decades before closing in November 2023