Salinger is a classic example of this. One of the most celebrated authors of all time. He really only wrote one full novel and then essentially disappeared from public view. Despite this I don’t think anyone would consider him a failed writer by any definition