Trying to adjust to a road bike

[Yen]

The LBS let me borrow a new Specialized Roubaix Expert for the weekend. This is the second full weekend getting to test a Roubaix for sizing. Last weekend I tested a 56cm Comp, and this weekend a 54cm Expert (the 54 is my size).

I'm 50+ and have been riding a hybrid. The hybrid has served me very well but we'd like to expand our horizons and go further, faster, join club rides and other organized rides, and be able to easily keep up.

I'm choosing a comfort road bike because I do not want to feel too stretched out. I love the way the Roubaix rides. I love the speed, handling, and smoothness of this bike. The fitter at the LBS will do a computerized fitting and get the bike correctly fitted to me.

That said............ I am wondering how long it takes to really feel comfortable, "at home" on a road bike. I tend to place way too much weight on my hands at the front of the hoods near the shifters. I'm trying to remember to just rest my hands there, not rest my weight on them, and to practice supporting my weight with my core and back muscles. I'm also trying to remember to bend my elbows more and let my back and shoulders relax and to not feel afraid of leaning forward a bit. Meanwhile, constantly having to remember this, pull back or adjust my hand position, etc. is diminishing some of the joy I otherwise have on the bike. I feel so focused on my posture and positioning, adjusting my neck and back, that I'm wondering if this is for me. I know it takes some time to get comfortable and a couple of rides a week apart isn't going to do that.

But, how do I know if I just need to get accustomed to this position, or if it's not right for me at all?

Anyone have any suggestions to ease my mind and help me relax and adjust?