Anecdotally, I've never seen a project be a career ender. Most individuals have many projects under their belt, it's rare that an individual has bet the farm on an effort in such a way that others would not employ them.

When a project fails, the lessons are often valuable for the next project - when a project succeeds it can often just be do to market position.