And is it better to have ambitious goals vs realistic goals? What might the impact of society be if we put up very ambitious goals but fail them all massively, what will happen to the trust of government institutions?

this. exactly why no one trusts their governments anymore.