That one is at Fiabilandia, near Rimini. And it's still alive and kicking I believe.
There's two of the same hardware in that park, did you look at Valle degli Gnomi? https://rcdb.com/1756.htmThis looks fascinating, a mine train worm! Will make sure to work it into a trip to Mirabilandia. Thanks.
But somehow this isn't the one I was imagining so there's another weird one out there. I remember it being almost a terrain coaster with scattered worm flower theming.
The Fiabilandia one is SO GOOD, it has dark ride sections and everything
Gardaland also has a cool custom one. Those Italians take their worms seriously!