I recommend against metal pipes mostly because of how quickly they heat up. And especially a short metal one like that which would get really hot where you hold it pretty fast. Another problem with shorter pipes is that it increases the risk of burning your hair or eyebrows.
The problem with the yellow one is that the bowl is a little small which limits your bowl size and makes it easier for it to fall out accidentally, but I'd choose it over the others just because it's ceramic. Wood pipes are a lot harder to clean usually, even if it comes apart. And I don't like metal pipes because it just seems like it's a little worse for you, but I don't know that for sure.
Out of the three you listed I'd go with the first one because it's interesting for one thing, but also because smoking out of ceramic feels safer than smoking out of wood or metal :/ I'd say just go for glass. They tend to be more fragile but you can get some thick, sturdy ones. Glass pipes are usually way more expensive too, though. If you trust yourself to be careful with it, you can make a glass pipe last a long time, but if you just want something to smoke out of without the risk of breaking something you spent a lot of money on, any one of those is fine.
