Why is it such a big deal that some numbers are irrational? It means they can't be represented as integer fractions. Cool. But almost all numbers satisfy that property. So why is it that, for example on $\pi$'s wikipedia page, already in the third line it tells us that $\pi$ is irrational?
Even if it had not told me that, I would've assumed it anyways. It's like if wikipedia had a page on a certain dog breed and told me "and you know what, this breed has a tail!".

It is a big deal historically. When the mathematics of numbers was developed, it was natural to start with integers and progress to rationals. Rationals are so useful that became the end of what was thought about, and eventually was like a religion: Every number is rational.
So when the first quantity was discovered that was demanded by Euclidean geometry, working with only integer lengths to start with, yet could not be a rational number, those mathematicians underwent somewhat of an existential crisis.
Another point, more relevant to the wiki page, is that it is not always easy to know that a specific definable number is irrational. As an example, consider $$\zeta(3) = \sum_{n=1}^\infty \frac1{n^3}$$
Although nobody ever expected this to turn out to be rational, or even algebraic, until 1977 nobody had proven that it is irrational. In 1978, Apéry proved it is irrational and this is important information (we still don't know whether it is transcendental). So the fact that $\pi$ has been proven to be irrational and in fact has been proven to be transcendental is indeed an important fact about $\pi$.