Nope ! Of course you must have more or less people that are for the Goal (on the Protagonist side) as well as against it (on the Antagonist side) as to avoid a storyline that feels too predictable. As reprehensible as the Goal may be, not achieving it results in Failure either way : how you portray the Consequence is entierely up to you.
Just remember : there’s an inequity at the heart of the story. Even if the Goal ends up, according to you, not being good for them at all ; only achieving this goal through the use of the OS Solution would bring an end to this inequity. So even if the Consequence ends up being better for them according to your Story Judgment, it won’t bring equity like a Success Story and won’t feel as triumphant as a result. How much you convey that is up to you, but it’s still there.
(As far as the OS is concerned, I’m not sure but not achieving the Goal wouldn’ bet a good thing for the Protagonist : he is defined by his role as a Pursue / Consider character and can’t objectively be good about it. However it’s a different matter for the MC who may, subjectively, feel good about it.)
As @bobRaskoph said, take a look at HTTYD as well as this article : https://narrativefirst.com/articles/when-failure-becomes-a-good-thing