> I guess the French want fewer people visiting their country?

I do not see any evidence that this is their goal. They would consider it an unfortunate side effect of a necessary environmental policy.

If the fee is paid on flights leaving French airports, then it follows that France wants people to go to France but not leave.

I don't think the policy has anything to do with tourism.