“Every day, I come by your house and I pick you up.

[Eric Cartman]

I always remember the ending wrong though, because Maffia has more or less the same ending but at the end the guy gets shot mowing his lawn.
In Goodfellas Henry actually makes it.  

its like the ending of The Shield TV show.

Sure, he's not dead. But it's not exactly a win for him.
Its not even subtext, he literally monologues how shitty his life is now.

Today, everything is different. There's no action. I have to wait around like everyone else. Can't even get decent food. Right after I got here I ordered some spaghetti with marinara sauce and I got egg noodles and ketchup. I'm an average nobody. I get to live the rest of my life like a shmuck.

huge contrast to his opening "As long as I can remember I always wanted to be a gangster".

It also makes it clear this isn't untrustworthy narrator with the Voice Of God end title card:

"his wife divorced him after 25 years"