"Has 'No Man's Sky' finally become the game that Sean promised?"
Short answer: No
He made a lot of claims being interviewed, including the infamous "you could meet another player but it would be extremely unlikely due to the size of the universe" and only now they have implement a limited presence of other players as floating orbs.
They have a ways to go before they get close to offering what was "promised".
I do, however, commend them for not dropping it, as has been done by EA and ME:A, and continuing to work on it. But really that's the least they could do and I can't help but think that they won't be releasing a second game any time soon. Who would invest in them at this point?