I can honestly say that if my wife were to try and immediately be successful, while of course I'd be happy, part of me would be hurt/sad/angry. Not at her, of course, but sometimes intentions and actions get crossed and I may take it out on her.
This is such an emotional process.
However, in my situation she has absolutely zero desire to be pregnant so that's not really an issue for us. She did say once that she would try if I couldn't, but I think that was because she thinks I'd want her to, and not because she wants to. I'd never ask that of her. If I can't get pregnant I think we'll look into adoption options.