I am curious, after I have one or more babies, will sex be as good as before? Will I be as "tight"? Or will I have to get surgery to tighten up?

Surgery? No. The female's body has a way of going back to pre-delivery state.