I mean, where are you getting "the majority" from? At least for myself and my company, we're heavily invested in Vue and we love CompAPI. Most people I interact with in the Vue 3 community also seem to like it with some niggles here and there (like the oft-misunderstood `.value`).
During the transition from 2 -> 3 it was a bit messy and I was even against the CompAPI originally, but after having actually used it in our app, it's miles better IMO. I understand all the pro-Options arguments and don't necessarily disagree with a lot of the criticisms about CompAPI, either.
OptionsAPI still exists, and probably always will, since it's already and always was an extra layer built on top of the underlying CompAPI, which itself was exposed publicly in Vue 3.