Calgary's contentious climate emergency declaration will stick around after an effort to end the action failed at city council.