I think the Park is functionally adequate and will service the community nicely. But I think an opportunity was missed in the design here. The park is trying to log jam too many little things into it and it's become the Landscaping equivalent of Homer Simpson's makeup shotgun.
Urban parks like this tend to be best employed having some grand centrepiece feature like a wading pool convertible to rink space, surrounded with 3-5 ancillary features bundled together and nice pathways meandering through the features towards a small restaurant/bistro/coffee shop.
For 40 million dollars, I hope they can do more, but I don't personally consider it a bad design.