This was a decent episode but DS9 did it better with Starship Down. This was kind of the start of the "lets have more kids on the show" phase and while it was cute to see Picard and the kids, it was also slightly annoying. I did enjoy the stuff with Keiko and Worf though.
Starship down is good, mostly because of Worf's part in it. Kira's pumpkin story didn't do much for me. It was meant to keep sisko from passing out. It's a miracle that it didn't put him in a coma...