I owned the game for about nine months and put 1200 plays on it at least. I sold it because I needed to get down to one pin for a while and decided to go with the slightly easier game (BM66) for er . . . my family.
Pinball is incredibly subjective and TNA is a unique experience so I can see it bouncing off some people, but I still miss mine and often regret selling it. I actually think it could work in a small collection -- it just depends on what you're looking for. I really toyed with the idea of keeping it as my only pin instead of BM66 because it's a great game for playing a couple of games a day on and you'll most likely never beat the game.
Anyway, the game definitely holds up to any pin out there in my opinion, it's just a unique experience so it might not work for everyone.