It is most definitely irrational, because there is no rational reason why the US has that position.
It was Roosevelt that did the deal with the Saudis. The deal was as follows: sell us your oil in perpetuity and we will make sure that nothing threatens the 'royal' family.
Note the naming of the Saudi Aramco state oil business. 'Aramco' has the letters 'am' in it and that is because it is the 'Arab American Company'.
You are correct that the U.S. has 'irrational' opposition to Iran. This is because the U.S. has irrational opposition to any country that does not care about the dollar. The only truly sovereign nations are the ones that the U.S. has 'irrational' opposition to, everything else is a vassal state.
They are about as strong as they can possibly be.
But at the end of the day, they're 32m people. 1/10th the US population or about the same as Texas or New York.
The US didn't "make ksa extremely weak"... they're weak because they're small.
Now that rationale is probably foolish in the extreme.
But they do have a rationale.
>In 1997, Fortune magazine named AIPAC the second-most powerful influence group in Washington, D. C.[46] According to journalist Connie Bruck, AIPAC has been able to "deliver the support of Congress"
https://en.m.wikipedia.org/wiki/American_Israel_Public_Affai...