Council leaders fail in last minute plea to end Aberdeen lockdown ahead of first minister’s press conference