In the end it doesn’t whether we go to infinity in one norm or the other.
Note that I am talking about finite dimensions, so I guess you didn’t mean the L^p norms or \ell^p for integrable functions or sequences but the finite-dimensional p-norms.
This theorem is completely irrelevant - the equivalence relation described by the theorem does not imply an equivalence between ordinal relationships imposed by different choice of norm. Also, "tails" isn't the same as "at infinity".
In the end it doesn’t whether we go to infinity in one norm or the other.
Note that I am talking about finite dimensions, so I guess you didn’t mean the L^p norms or \ell^p for integrable functions or sequences but the finite-dimensional p-norms.