Well my theory why pierce doesn't work in macro is that it may share the same name of a "Fencer" skill, and since Fencer class isn't activated yet, that's why it doesn't work. That might be a spoiler for future updates.