The US president made the tariff announcement as he brought his two-day visit to Ireland to a close