I enjoyed it for what it was, and thought it was good for a Star Trek pilot. As pilot episodes are usually worse than the series as a whole, and this was arguably the best Star Trek pilot, it seems to be a positive for the series.
I liked the "twist" that Ensign Mariner is actually Captain Freeman's daughter. It helps explain why she's such a screw-up quite nicely, in that she cannot (despite being intelligent and competent) live up to the lofty expectations of her mother and father (who is an Admiral) and thus at some point says "fuck it" and stops caring about advancing through the ranks or the chain of command. She's arguably a better done Tom Paris. It seems weird Starfleet would allow her to serve on her mother's ship, but I guess it could be excused since this appears to be her "last chance" to make something of herself before getting drummed out.
I also enjoyed that once you get past Mariner everyone on the show appears to be doing their best, whether the bridge crew or the ensigns. The humor comes not from seeing people act like idiots, or be awful to one another, but from absurd situations and weird slice-of-life non sequesters. Otherwise though it's a recognizable episode of a Berman Trek show with an A/B plot and a crew working together to do their best.
One thing i liked a bit less about the episode is so little work was done fleshing out Ensigns Rutherford and Tendi. Rutherford got a B plot basically to himself, but all we basically discover about him is he's a "nice guy" who's all business. Maybe that's the joke - that he's not a very deep character? Seems like thin gruel though. Tendi is basically just the wide-eyed newbie and doesn't seem to have any other personality characteristics in the episode. I recognize that it's impossible to fully introduce the main characters in a 26-minute episode, and they'll probably get "focus episodes" later. At the same time, that's why most pilots are extra long, suggesting that maybe they should have gone with a 50-minute opener to allow for more time for the entire cast to be introduced at once.