You’re not doing anything wrong. It is just that the pipe character used within the link to denote the following display text gets interpreted as being a pipe character used to define the end of that cell in the table.
If you add a \ before the pipe character, it will work correctly. As an example, see some of the links in the table here: Regular Expressions in Obsidian (copied from mdn web docs).
Good luck!