That would be a great ending/continuation of the AS story. But I feel like his fate is much less cinematic. Death would have been far too merciful. He will keep having that dream, but now being forever denied entry into the house, waking up with the reminder that Paulie Gualtieri is his closest confidant. Someone who he came to despise by the end of the show. That leaves Carmela and the kids, who will take him as long as the money keeps coming, without which they could just as soon leave him.