It was pretty good. It didn't blow my socks off, but then again, I was barefoot at the time. I thought the references to the movies and each Avenger was nice and Phil Coulson was the best part of the episode, hand's down. I would still recommend watching it.
Speaking of the Son of Coul, I was intrigued by the explanation for his resurrection and a secret. Head down below for more, because there might be a few people who haven't seen the pilot yet. Poor dears.
Okay, so here's the bit that got my attention about Coulson not being dead. Maria Hill and a S.H.I.E.L.D. doctor, Streiten, have a brief conversation after Coulson leaves the room where they are. Coulson had mentioned being revived by medics after getting shanked by Loki and that Fury had used his "death" to motivate the Avengers into acting as a team, and after that, he had been sent to Tahiti to recover. Streiten asks Hill that "he really doesn't know, does he?" to which Hill responds "No, and he can never find out." Now, I had a theory about how Coulson survived his encounter with Loki in the Avengers movie, that he had used a LMD - Life Model Decoy, an android designed to be as an exact duplicate of a person as possible - and that was what Loki "killed". The pilot trashed that theory, but part of it might still be relevant.
I think Phil Coulson is an LMD. I think he died in the movie and Fury had an LMD built to take his place. Maybe they somehow transferred his memories or even his entire consciousness into it, then simply told Coulson that the medics had revived him. Who knows, maybe the revelation could cause him to have some sort of breakdown or critical systems failure.