I think Kagha and the child is one of the very few examples when the roll mechanics actually work very well. I wish more of them would be like this one. As I see it, Larian really wanted to kill this child to establish Kagha's character (which is legitimate, it's a very good scene because there is an element of an accident to it but the way Kagha responds later is an excellent character moment and really interesting), but also wanted to stick to their philosophy of "ENDLESS CHOICE AT ANY COST EVEN IF IT MEANS SCREW THE STORY", so what they did very wisely is to give us a very hard roll. most players will get the story as they intended, and the few who'll be successful will get less story but the feeling of success. a great moment in my books. and of course the most important part about it - no super great affects on the main story. so you can fail and not lose too much (and as I say, I think in this case even gain a fascinating character arc).

Unfortunately, most dice rolls are not like this. most result in either battle, no option to move forward in a quest, or success.

Larian's Biggest Oversight, what to do about it, and My personal review of BG3 EA
"74.85% of you stood with the Tieflings, and 25.15% of you sided with Minthara. Good outweighs evil, it seems."