Officials have said it would be a “terrible shame” to see a tourism initiative between Ireland and Wales close due to funding issues over Brexit.