No, credit card car insurance doesn’t cover RV, camper vans, or exotic cars.
Your personal car insurance also might not cover it, so best to check before booking.
Unfortunately, it might make most sense just to buy the specialized RV insurance from the RV rental company.