Powershell's -replace supports lookaheads:

(Get-Content -Raw file.tsv) -replace '(?<=\t)\\N(?=\t)','' | Set-Content file.tsv

It removes \N from empty tsv cells for 900mb file in 7s. But beware of possibly converted line breaks.