Indeed. This one has to be the very first episode where I thought "I might want to rewatch that at some time" - namely, if we learn more about the whole Sarek-Amanda-Spock-Burnham relationships. Either after having new DIS episodes adressing that, or if I catch a re-watch of another series (say, TOS "Journey to Babel", or the TNG-episode with Sarek), then this episode might be relevant to check to see what happened before (or after) in a new light.
All the other episodes were rather "meh". Were I was glad I watched them to see the story unfold, but didn't find any one memorable or interesting enough to check out later again. To be fair, that wasn't the case for many other Trek series in their first 5 episodes as well (although, we had stronger pilots before).
Not very many. I've rewatched all the pilots recently except Emissary. The only one(s) that even come close to DSC are the earliest TOS episodes - and that's only if you're willing to engage with them entirely on the standards of their time rather than today, and (in the case of The Man Trap, the actual first episode aired) if you don't mind a pilot that basically tells you almost nothing about the characters or the world involved and tends to portray many of them wildly out of character in relation to later episodes.
My memories of Emissary have always been good, and it was the only one I'd watched multiple times before now, so I still trust enough in that to say that we have indeed had 1 better pilot episode (two-parter) than what DSC has accomplished. But that's basically it.