I think in the context you state, the woman meant meant to ask Bond if he was capable of having a deep relation with a woman, whether he just considered them as momentary pleasures. In general terms, a meaningful pursuit would be something that would be considered to have (either by yourself or by society at large) any lasting value beyond simply short term enjoyment or pleasure.