When I was young, I was taught that $\pi$ was $22/7$ and that its decimal expansion didn't repeat (which is equivalent to "it is irrational.") Since we had been taught long division, I tried dividing $22$ by $7$ and it definitely repeated. It led to what I still consider my first "proof" - I was able to convince a friend that any long division of whole numbers would always repeat (or terminate, which I later realized was the same as repeating $000000\dots$.)
Why is $\pi$ irrational? There are plenty of proofs of the fact, but, given the nature of your question, I'm not sure you are looking for proofs. You seem to want a deeper explanation, and I can't give you one, but I can tell you the following:
Almost all real numbers are irrational.
There is a technical sense in which this is true, but the important thing is that there are way more irrational numbers. Staggeringly more. It is probably too soon for you to understand this technical definition. I can recommend a popular treatment of this idea in a book by George Gamow called "One, Two, Three, ..., Infinity." Not sure if there is anything more recent.
Because of this startling fact, mathematicians are not surprised when a numeric problem results in an irrational number. Instead, mathematicians tend to be surprised when an expression that is not clearly a rational number turns out to be rational. When some complicated expression ends up rational, that is when mathematicians tend to ask "Why?"
So the fact that $\pi$ is irrational does not make it special. $\sqrt{2}$ is irrational, as is $\sqrt{3}$, $\sqrt[3]{7}$ and any root that is not an integer.
So why is $\pi$ important? At heart, it is probably because, in some deep way, circles are important. So there are lots of problems that don't appear to be about circles, but when we look deeper, we find that we can get an answer in terms of $\pi$. In some fundamental way, $\pi$ crops up a lot. There are some other constants like $\pi$ that crop up a lot, like $e\approx 2.71828$. $e$ is also irrational (and there is a startling relationship between $e$ and $\pi$ that is one of those "deep" facts about circles.)