The exclusion does not care that it was intentional
Homeowners policies exclude water that arrives across the ground, and that wording covers irrigation exactly as it covers a storm. Water released into your yard on a schedule, backing up into the house because a berm failed or a door threshold was low, is surface water and it is excluded. It surprises people precisely because somebody turned it on deliberately.
Berms, grading and thresholds are the real protection
Keeping irrigation water out of a house is a landscaping and grading question rather than an insurance one. Berms that have settled, drains that have silted up and thresholds that sit low are the usual causes, and all three are maintenance an owner controls.
A neighbor or a district may be liable, separately
Where water escapes because somebody mishandled a gate or an irrigation structure failed, there may be a claim against that party. That is a liability question rather than a property one, and it proceeds quite separately from your own policy, which will not be paying in the meantime.