what happens to the vagina after birth?

I don't mean right after cause I can't imagine how swollen and red it is but after a few weeks and first time having sex. Is it really gonna just be a huge hole? Does your husband still feel pleasure? 
I've been so nervous and thinking so much about this :/