A lot of the ideas your team dreams up in the conference room sound like great ideas at the moment of conception. How many of those ideas really weren't so great after all, but you moved forward either because you had already invested significant time or money? How many times has your cooperation done the same to you?
Was it worth it in the long run?
Two things here:
Number one is always be willing to re-assess a project and abort or significantly change. What good is even a marginal return on investment at the expense of future failure, negative resident outcomes, and lowered staff morale?
Number two is never abort without a plan and an explanation. Otherwise you're just one more person that never follows through, even if the people around you felt the same way about the project.