FYEO is an amazing Bond film - one of my Top 5 - but yeah, there's a deafening hypocrisy in Bond's behavior when Melina wants to avenge her parents' deaths when only a number of days or weeks before 007 himself finally got revenge on Blofeld for Tracy's murder and happily dropped him to his death. I guess that could be one of Bond's unacknowledged attributes: he frequently does the things he tells others are bad to do. Perhaps because he knows killing his his job and sometimes you have to be a hypocrite?
Who knows...but thankfully it never affects my enjoyment of FYEO even if the dialogue stands out in stark contrast to the pre-titles sequence. Or even Bond's ruthless hunt for Blofeld in an attempt to avenge Tracy in the pre-titles sequence of DAF. The man went around the world randomly beating the snot out of or even choking people to find out Blofeld's hiding location.