While we have heard of some RV parks not allowing motorcycles in the park, we have not encountered any. We did see one when researching an area for places to stay before, but that one didn't make the cut for obvious reasons...
Some do have a policy to only ride in and out of the park from your site and not "cruise" the park. We completely understand that. Most RV parks and campgrounds are completely fine with motorcycles, even if you have two. We see it all the time.