what advice was great when you first heard it, but has aged like milk since then?

those are impacts from production. once it's produced, drinking it has no impact at all.

but I would be remiss if I didn't point out that your link relies on poore-nemecek 2018, which ignores the fact that LCA studies cannot be combined. it's bad science.