A compromise for the rainbow design on one of Bristol’s most iconic views has been dismissed by local council officers – and now it will be removed