I don't know about people in general, but those I spoke to a few years before the invasion told me on numerous occasion that they would prefer that Crimea belonged to Russia, and that they would be much better off then. of course, this doesn't mean they supported the invasion in any way, it was just an opinion.
After the invasion cam ethe period of disillusionment. It turned out the situation only changed for worse. But nobody should be surprised there was practically no opposition when Russians took over Crimea.