In this case, I think the author is looking at raw processing from almost an 'archival' perspective, which is really how we all should do it, strictly speaking. In the real world though, I suspect most of us take some photos, likely with the intention of online viewing, and process them straight away for that purpose.
The author is looking at it from the viewpoint of "I don't know if I'm going to print this photo or display it on the web, so I will get it ready up to a point, and sharpen it etc appropriately when the time comes." This is efficient, but by no means absolutely necessary, because the non-destructive nature of raw editing means you can simply adjust the sharpness later on anyway.
He also uses a somewhat odd workflow where he exports a TIFF to edit further. This strikes me as a waste of time and hard drive space.
As for Lightroom taking your sharpening into account before publishing, I wouldn't bet on it. The look of a photo is subjective - how is it supposed to know if you think the sharpening is enough or not?