Yes, if you have to cancel your holiday, you can also cancel your rain cover and get a refund. Otherwise, if your holiday has not been cancelled, you cannot get a refund on your rain cover.
(You can find information about holiday cancellation insurance here.)