Tried anal....😖

So after 6 years with my hubby we finally tried it... After reading stuff on here I heard advice such as lots of lube and most of all relax... Well I took this advice and after him only poking it in slowly I almost screamed and started crying lol obviously he stopped and that was the end of that. I know he wants to try again at some point but it freaking hurt!! Will it get any better? What do I do? I wanted it to feel good... I was disappointed with it all but not as much as him lol he said it felt great for the one second it happened... But he is totally okay with whatever I decide. Ugghh how do I deal with this??