It's not a contradiction. Not appealing the ruling would leave the status of marriage unclear. By appealing, Bloomberg is sending the case on its way to resolution one way or the other.
The thing is if most people in New York truly wanted SSM then it would not make any sense for them to support the mayor's idea of appealing the judge's ruling.