Yes, and I own it, and I can say it is a very good game:)
Also, I think that if Tingle makes an appearance in a Zelda game again, it's probably in one of the cel-shaded/cartoonish titles, like a post PH game... I don't imagine him in a realistic game