I am remembering my turmoil when I decided to leave my husband.
It took a long time - for about a year I agonised over it, thinking I couldn't possibly 'do this' to the children but seeing no way of staying in the (abusive) marriage. It was a time of real turmoil for me. My husband, whose parents had divorced (and handled is extremely badly), laid it on thick that the children would be destroyed for ever by a divorce - I believed him.
Then one day I watched a documentary about the effects of divorce on the children and tbf it was harrowing viewing. I suspect now that the documentary maker had an axe to grind as it certainly wasn't a balanced view but heavily one-sided. My husband (to all intents and purposes ex by this stage but living in the same house) had watched the programme downstairs and as I stumbled to the loo in abject misery after watching this wretched programme, he was coming upstairs and I saw the look on his face: triumph. He had been proved 'right' by the documentary. There was no torment on his face, only triumph that he was 'right'.
Perversely, this made up my mind. I felt my husband's cover had been blown and his real motives revealed: to trap me in the marriage by hanging the children's welfare over my head. At a deep level I couldn't accept that the documentary was balanced and felt there was more to it than that - that the end result didn't have to be emotional ruin for the kids.
My boy took it hard if I'm honest. I think he is still processing it now (but with the added complication that his father has died) and he's now in his 20s and was a toddler when the marriage split. Though that could be me with the guilty undercurrent still running through (how to shake that off?) but I don't think he processed it well at the time or subsequently. I have to say that my ex made life unbearable for me until the day he died and that had an effect on the kids, of course (not that I said much to the kids, hardly anything but at some point something had to be flagged up about what was going on, as it was confusing for the kids). My kids had 'support' from CAMHS (which actually made things worse - i wouldn't recommend them) and also some art therapy, which seemed to help a lot.
One of my boy's housemaster lost his dad when he was 15 to cancer (not the same, but divorce is liek a kind of death, a bereavement) and he says he didn't process it properly until he was in his early 20s. Maybe boys do things differently. My girls made a major fuss when we divorced and made their feelings known (also when their father died) but my boy was much quieter. That could be personality though and not gender. But imo boys do generally culturally process things differently to girls.
If you handle this well, you can make it successful. Is your husband a reasonable man? Will he make things hard if you leave? Perhaps people around you are suggesting you maintain the status quo because they suspect he could be difficult..?
Sorry I've drivvled on - a lot to say I suppose. I think I may be confusing the divorce and the (actual) bereavement too. apologies if so.