Irrational numbers, in practice, cause lack of precision. So, for example, if you draw a square 1m x 1m, its diagonal isn't sqrt(2)m. It's some rational number because that square is made of some discrete elements that you can count, and so is its diagonal. But, upfront, you won't be able to tell what exactly that number is going to be.
Another way to look at what irrational numbers are is to say that they sort of don't really exist, they are like limits, or some ideals that cannot be reached because you'd need to spend infinity to reach that exact number when counting, measuring etc.
So, again, from a practical point of view, and especially in fields that like to measure things or build precise things, you want numbers to be rational, and, preferably with "small" denominators. On the other hand, irrational numbers give rise to all sorts of bizarre properties because they aren't usually considered as a point on a number line, but more of a process that describes some interesting behavior, sequences, infinite sums, recurrences etc. So, in practical terms, you aren't interested in the number itself, but rather in the process through which it is obtained.
* * *
Also, worth noting that there's a larger group that includes rationals, the algebraic numbers, which also includes some irrational numbers (eg. sqrt(2) is algebraic, but not rational). Algebraic numbers are numbers that can be expressed as roots of quadratic or higher (but finite) power equations.
These, perhaps, capture more of the "useful" numbers that we operate on in everyday life in terms of measuring or counting things. And the practical use of these numbers is that they can be "compactly" written / stored, so it's easy to operate on them and they have all kinds of desirable mathematical properties like all kinds of closures etc.
Algebraic numbers are also useful because any computable function has a polynomial that coincides with it at every point. Which means that with these numbers you can, in principle, model every algorithm imaginable. That seems pretty valuable :)