Well, it only works for a short while, depending on the strength of the potion. There's also a spell that lets people do that, but so far I haven't found a spell book to learn it.

Argonians don't need a spell or potion to breathe underwater.