FWIW McCarthy didn’t investigate Hollywood at all. That was the House Committee on Un-American Activities. Being a Senator McCarthy wasn’t on that committee.
He specifically investigated communists in the government.
When state and local officials defy and obstruct Federal law and even make declarations that Federal law does not apply in their jurisdictions I don’t know what else it could be called other than insurrection.