Was King Louis XVI against the revolution?

Yes he was. The revolutionaries wanted a republic, but of course that was not possible as long as they had monarchs, and therefore were a monarchy. To truly be a republic, the revolutionaries needed to get rid of their monarchs. Since King Louis XVI was a monarch, he was therefore against this revolution.