Yes, the splash pads are off at this time of year. The City makes a call as so when it's warm enough to turn them on but it's usually in May.
I've been there several times over the last few weeks and the water has been off every time. Can't say when they'll start turning them on again, but you might be fine if the birthday party is soon.
Thanks! Your answer is awaiting moderation.