I think it has come a long way, which is great. How good it is is sadly dependent on the actual school. We went through and incredibly prolonged difficult period of time.
At the primary schools they were amazing. Head teacher took time to chat to my DSs not about what was going on necessarily, but just so that he knew they were there and cared - that helped him a huge amount. They checked in with me at all times to see if there was anything. Else they could or should do and I felt listened to and supported the whole time.
In high school DS didn't want the teachers to know what was going on so was given a card from support services that he could show to the teachers if he needed to leave the class without having to explain why he was leaving, or the teacher even commenting on it. He never used it, but knowing that he could helped him a LOT.
They also had available a unit where he could choose to do all his lessons with the support teacher's assistance if he couldn't face actually going into class, to keep him in school. None of the other parents even knew it existed but it was there, and used l, heavily on occasions, by children who needed it.
Compare that with someone I know from my childhood who had a suicide jumper from a multi story car park land a couple of meters in front of him, and covering him with blood etc, in the 80s. He used his school blazer to cover the body up until ambulance and police arrived. Apart from taking his name nothing was ever done re support for him. Not even to just talk it through with him to help him process it.
But... I think we can go too far sometimes. A teacher at infant school had lost her adult daughter in a hit and run. The parents were frantic as to how they could help their children cope with this. She was not someone they had ever met. A small school so they did know the teacher well. I remember telling my 6 year old DS about it. He had a really sad face and said "oh that's so sad. Poor Mrs x". Then turned around and asked if he could go and play such and such a game. As parents we were feeling OUR distress at the thought of losing a child. They children themselves weren't suffering a loss and apart from needing to be aware of why their teacher wasn't there, really it was too distant to them to have much of an impact.