In his last moments of lucidity, David tells Lucy that he wasn't able to fulfill his mother's dream, nor Maine's dream, but she can fulfill her dream.
Falco and Lucy escape, and David faces down Adam, and loses.
Cyberpunks always die or go psycho, so this is the good end.
That's the show.
So, what's my takeaway?
I joked at the beginning that _Ghost in the Shell_ had dropped the ball recently. _Cyberpunk 2020_(/2077/Edgerunners) has always been the pessimist to GITS Optimism, so it shouldn't come as any surprise that this was a tragedy.