You typically don’t pay these taxes where you register your plane, but where you land/take off and in which country you fly.

So it may reduce the number of flights (esp. empty flights), which is actually good.

If the money is reinvested to develop high speed trains, the impact on tourism would even be minimal.