A) it was Wesley
B) the situation isn't really comparable because it was to prevent a war and not to score a luxury resource
C) meeting Kirk, fighting the Borg against orders and fighting the Dominion surely changed his point of view.
Heck, the events of that very episode might have changed his opinion.
Wesley is the hero of that episode, not Picard.
A resource that could cure billions suffering from a war is not a luxury resource. And it's certainly not something you put the sentiment and feelings of 600 over.