Arizona gets 35% of its water from the Colorado River [0]. "A literal drop?" I wouldn't agree.
However, since reductions affect various water-using constituencies differently, Tier 1 reductions don't have an effect on municipalities' water availability (but future tiers do) [2].
Again, largely important points you've raised here, but it's also important not to understate the value of the Colorado River / Central Arizona Project in municipalities' water availability and water contingency planning, as you have.
[0]: http://www.arizonawaterfacts.com/water-your-facts [1]: https://www.nytimes.com/2021/08/16/climate/colorado-river-wa... [2]: https://www.amwua.org/blog/tier-1-shortage-what-does-it-mean...