Substitute red wine vinegar for sherry vinegar?

Yes. The tastes are so similar that there will be little to no difference in your recipe. Many times the different colors are chosen simply for the color. For example, in a white sauce, red wine vinegar might change the end color of it. Appearances only! Taste will be fine!