It's not improbable that he was privately opposed to it, but he had to be publicly in favor of it in order to not undercut people like Vijaya Gadde and Del Harvey. Remember that Dorsey was also CEO of Square at the time and doing a bunch of crypto stuff. Dealing with Twitter drama was probably not the hill he wanted to die on.