Controversial project to ship heavy crude to Texas coast was killed by Biden administration on environmental grounds