That Sisko was being irrational due to not having moved on from his wife's death is one of the whole points of that scene. Oy gevalt.
I guess even in the first episode DS9 was muddying the protagonists and setting us up to not always root for them.
It was the right choice in terms of the narrative, but you can see how it pissed off the fanboys.
I think it would have been great if Picard had made an additional cameo later in the series though - if for no other reason than to reinforce that Sisko had moved on and healed.
 
				 
 
		 
 
		 
 
		 
 
		 
 
		
 
 
		 
 
		 
 
		 
 
		 
 
		