As a consultant there's no point in being so personally involved in the project outcome that you let it impact your health. Follow management orders, do the best work you can, and let the chips fall where they may. Whether the project succeeds or fails, you'll get paid either way and eventually you'll get reassigned to another client.