So...my thoughts on this.
On one hand, I get how one might consider this a worthwhile direction for the character. Law enforcement has been part of Gargoyles' DNA from the start, in a way that has been quite specific to it--not even Batman: TAS features cops so centrally, and law enforcement is not at all part of its TMNT DNA--and, with gargoyles getting a measure of legal recognition, in recent stories, it makes sense for their usual work in the shadows to change in some respect. What's more, there's clear dramatic potential: not only does it give Goliath some new characters to interact with, it also puts him in a position to question his loyalties and practices (no reason to assume a group dealing with gargoyles will work for them). And again, seeing Goliath in this new context would also shed some much-needed light on gargoyles' current status quo.
This still feels really ill-conceived. Given how public perception of cops has changed since 1997 (or even 2004) and how important it is to Greg Weisman for him to be seen as a progressive, I'd have expected the current revival would disassociate the gargoyles from the police. The "Goliath on trial", in fact, seems perfectly positioned to do exactly that, and if Elisa had been actually permanently fired as a consequence of her actions during that story, it would have made complete sense. Instead, we not only still have Elisa as a cop, we now have Goliath as a member of the Gargoyles Task Force, complete with badge--not the development I imagine very many fans were hoping for.
Does the direction have potential? Sure. But that can be said of the millions of developments since the original cartoon series ended. Gargoyles' problem has never been lack of stories with potential: it's that there's simply far to many of them for any of them to get the development they need, and this is just another thing to be introduced and not serviced, even when the nature of the story demands it.
Since this development, we've had one entire arc spanning multiple in-universe months--Elisa's months-long suspension after Goliath's trial has come and gone--and during this time, "Goliath is a cop" has simply not been a factor, and has seemingly changed absolutely nothing about how the gargoyles live or operate. One could have excised the panels referencing the development (all...five of them?) and nobody would have been the wiser. What's more, what we have seen has featured no conflict (internal or external) and no character development. One moment we're told that "the NYPD" has made an offer, and another panel where Goliath has already accepted--just enough material for GargWiki to be able to say it happened, but nothing that makes an actual story.
In storytelling ecologies, there are certain stories that are like cacti: they don't need a lot of constant attention, and they work perfectly fine as something that is given focus only occasionally. This is how Gargoyles the cartoon worked most of the time, in part because it generally had a very stable status quo; it is not how Gargoyles the comic, with its constant status quo changes and BIG DEVELOPMENTS, works. "Goliath joins the Gargoyles Task Force" is not something that you can pick up months down the line: it is, inherently, a story about first impressions. If that is not a story Greg Weisman wasn't interested in telling, then the development shouldn't have happened at all.