Hi Krystal!
Firstly, Congratulations on your second pregnancy!

In the past c/s were performed differently. The scar used to be vertically when now it is horizontally in most cases. A vertical scar doesn't heal as strong as the newer horizontal scar. Add to that the fact that OBs are much better at performing c/s these days (they've had a few decades of practice) and the scars are much stronger nowadays. But the old daying still rings in many ears: "Once a cesarean, always a cesarean". With the old type of scars, the risk of a scar rupture was a very real one. But it is greatly reduced with the new techniques.

There have been many studies done on this subject and the conclusion usually is that in a normal pregnancy, a VBaC (vaginal birth after cesarean) with no interventions (no induction, no epidural) is safer for mother and baby than a repeat cesarean. The World Health Organisation has this to say:
There is no evidence that a caesarean section is required after a previous transverse low segment caesarean section birth. Vaginal deliveries after caesarean should normally be encouraged wherever emergency surgical capacity is available.
I am actually really happy to hear that your OB is supportive of a VBaC. Although the statistics support his attitude, a lot of women have to fight for the right to have a VBaC.

I would suggest that you do some research on VBaC. This is a very good place to start: https://www.bellybelly.com.au/birth/uterine-rupture

The decision is yours and nobody can make it for you. But it is good to see that you are being offered options.

All the best, whatever you decide.
Saša