Yes, some makeup foundations do irritate rosacea.  Always check the label to make sure that your makeup doesn't contain any rosacea triggers.
Here is a list of some makeup ingredients that will irritate rosacea skin:
Alcohol
Fragrance Additives
Menthol
Peppermint
Eucalyptus
Mineral oil
I've written a detailed guide on the best foundations for sensitive rosacea skin. Check it out if you're having trouble finding the right foundation to cover your rosacea.