It is not only possible, but all too common for a website to be perfectly optimized for a set keywords, and fail to draw in new visitors. Often this is because a website design company is passing off high search results as a successful job, but they have used a set of keywords that had little competition, or put them together in a way that is rarely used.
As an example, I have held the top Google search position (two, actually) for
