Pipeline, closed since 2015 after huge oil spill, reopens after president cites need to boost US supply amid war on Iran