Last season, the Herald reported dozens of complaints from parents about children missing five out of 16 scheduled games because of water-logged fields.
In a budget meeting, Mayor Len Brown voted against a $12.5 million increase over the next two years for upgrading fields.
Ms Coney said the council study confirmed the need for additional playing capacity to meet demand in a rising population of younger people.
"One of the goals of the Auckland Plan is to make children a focus so, yes, it is disappointing."
The $100 million extra would have given 20 new artificial fields and sand carpet upgrades and improved drainage to help meet shortfalls for training.
The present regional budget for capital improvements to fields is about $20 million.
Sports parks manager Mark Bowater said the $87.5 million would go a long way towards addressing supply and demand problems.
The shortage of good playing surfaces was a constant theme of the local boards' submissions on the draft Auckland Plan.
Mangere-Otahuhu board chairman Leau Peter Skelton said a number of parks in his area were almost beyond seasonal use for soccer, in particular.
"Local clubs are failing - removing more forums for healthy and disciplined activity for youth. Significant investment now will see a raft of benefits in the future, including decreased health and policing costs."
