This is a really difficult one. Irrigation may initially be provided to help communities become more resilient to drought. However, land use in areas supplied by irrigation will almost certainly become more intensive in order to pay for the costs of the irrigation.
The climate change stocktake report (page 18) likens this risk to structural protection works which "may also build a false sense of security and further demands for protection thus locking in exposure to risk over the long term."
These are the posts I have shared on social media, all in one place for easy access.