Whoopi Goldberg says she chose her career over her child because the opportunity for success 'would never happen again'