so, basically, 4 and sqrt(2) aren't some different types of quantities (types which would have differept type properties, like they would behave differently in what quantity they mean), they are exactly the same type - definite quantity, static, finite.
and the thing with irrational numbers is that the mathematical language used to expressed them (fractions) can't actually express them. like you can't express 1/3 in decimal, so you have to use periodic fractions to clarify what you mean, and you can't express irrationals using fractions or non-secondary language construct (as in, not through an operation like sqrt()), so you have to use limits and functions to clarify the meaning. periodic fractions and irrational numbers aren't "infinite" in the same way, but the concept of their inability to be expressed finitely is the same, it's just the problem that makes them "inexpressable" lies in different expression types. number system for periodic fractions, fractions for irrational numbers.
so "irrationality" of numbers isn't actually a property of numbers, it's a property of the language used to express them, and that's why everyone everywhere defines irrationals as "something that can't be expressed using X". because it's like saying "there are numbers just like other numbers, with the exception that you can't write these using fractions, so enjoy your math". like, "you don't see them in this language, but they are there, here's the proof: sqrt(2)"
... and if we come up with some other mathematical language or an extension to the existing one that would be able to express irrational numbers concisely like it can ordinary fractions, then we wouldn't even need the distinction between them, since it was purely practical: see these numbers, don't do this to them, it doesn't work in the language we've chosen to operate with numbers, and you'll be fine