Have you not seen the signs that clearly tell the public DO NOT GO INTO THE WATER? Those water channels are not for public use!Sure, Sugar Beach doesn't offer the level of interaction with water that Crown fountain does, but Sherbourne Common a block away does. The sculptural pylon fountains are pretty stunning at night, and the stream that leads from them has already become a spot for kids to wade and play in. The steps leading into the stream have also become sitting areas in the summer. In the winter, the splash pad becomes an ice rink - extending its use through the winter, whereas Crown Fountain shuts down for the season.
The only difference is the park is still in the middle of a construction zone. Give it 3-5 years and I am sure it will find its place.
If a carbon copy of Crown is the only thing you are looking for, you will forever be disappointed.
That being said, I do agree with @Torontovibe above, in that we need more year-round design for parks, especially on the waterfront. One thing I like at Trillium Park is the addition of a fire pit. It's a great way to attract people to a space in the cold winter months, and the waterfront could use some help during the winter.