Now there is a question I have never heard before...
I have never seen this addressed on any appraisal, so I have to say NO. An appraisal's primary purpose is, of course, to determine the fair market value of a property. FHA has added the purpose of assuring the home has no defects which would threaten the safety of the occupants or reveal structural defects in the construction. They are concerned with swimming pools, for instance, as an empty pool or a contaminated pool could be a health hazard. I can think of no such threat by not having the lawn sprinklers work.
The appraisers are charged with checking the utilities, to assure the home has electricity, running water, etc.; all for the purpose of determing livability. No such purpose would be served by requiring the sprinklers to work.