You don't mention your weight, (and I'm not prying), but have a look a
THIS blog.
The author is one of our own, (
@gb155 ), but he's not on here much these days, although he is still cycling
FYI - I'm a bigger guy, always have been and probably always will be, but in the past I've been pushing 20 stone, yet I used to ride carbon framed bikes with 20/24 spoke wheels without any issue, well I broke one rear spoke after 2 years, so I regard that as without issue
As for confidence, it will come. When I first rode a modern rode bike after years of MTBing I nearly $hat my pants
I used to have to slow right down just to reach down for a bottle, but the more you ride the more natural it will become.
So well done, now go for a ride
PS: Cannondale make great bikes