You seem to know most of the pros and cons of hybrid vs. road bike uses.
Since you are almost 50 (I'm 54) the slightly more upright posture of the hybrid (or of a touring bike) might be more comfortable- also might be more comfy on the saddle parts.
I'm not so sure about the 'getting into shape faster on a road bike' though- you'll get into shape fast on either, depending on how many miles you ride. Hybrids tend to be slightly heavier than road bikes in general, so your legs will get into shape for sure.
Lots of women start out on hybrids and after riding a while and getting confident, they then want to get a road bike. Nothing wrong with that either. It is true that hybrid are a bit less intimidating to new riders than road bikes. If you already have some riding experience then by all means test ride some road bikes in addition to the hybrids.
Some people eventually have two bikes- their first hybrid that they've now converted to a commuter or errand/fun bike, and their fasty road bike.

For long distance riding, a touring bike (with gravel-ready tires) is another consideration. A touring bike is a road bike with slightly more relaxed geometry and slightly more upright body position- it's designed for long distance comfort, and will also have the ability to carry saddlebags or camping gear. It also comes with fork/brake clearance to be able to put wider tires and/or fenders on.
Also, you can sometimes put straight bars on a road bike. But if you plan on very long rides then straight bars are not going to be as comfy as traditional roadbike drop bars where you can change hand position often.
If you get a bike that fits you well, then you are going to love it and have tons of fun on it whether it's a road bike or a hybrid.
One last tip- don't be too nervous about it all- you can always sell a bike and buy a different one at any time should you feel you need something different.