Is it normal to have cotton mouth after having your tongue pierced?

Yes it's not uncommon, just stay on the cold stuff and you will be fine.