The theme park was once a popular family destination boasting thrilling rides including the legendary Knightmare roller coaster