If a hypothetical project were determined or designated to be “in the national interest” under the Building Canada Act, there's no automatic exemption from the tanker ban. The law does not provide for exemptions. It provides for streamlined approvals.
For authorizations listed in schedule 2, the tanker ban is not one of those pieces of legislation listed in schedule 2. By virtue of being designated under the act, that would not be an automatic result.