I have not taken the mesalamine foam, but I had this problem with the regular mesalamine enema. I was also v. nauseous. I never have this problem with the steroid enema, and since they give me better results I switched to them.
BTW-am updating my signature, I do not take Rowasa anymore (for the reasons above).