Hi, Would U Tell Me Is Sex Painful Or Pleasurable

Hi, Would u tell me is sex painful or pleasurable for normal woman. When I was very young I was told that sex is performed through woman pee hole. Right away I came up with a notion that sex is painful for woman. Still
I think that way. I need your help.