I don't know if you'll think this is helpful, but learn to play songs you already like. Barring that, what type of music are you looking to play? Irish, Scottish, English, bluegrass, blues, fusion jazz, rock, latin?

That'd help us "pros" suggest songs. But really tin whistle can be used to play lead, harmony or percussion in almost any song.