...
My own floor plan "failed" here in the forum, ;-) so my opinion probably only has limited value, but I find your floor plan okay.
Are roof windows planned? If not, maybe you could inquire about prices to see if it is feasible. Then the rooms on the upper floor would be brighter. (In our previous house, we retrofitted roof windows in two rooms and the difference in comfort was enormous.) Maybe it is at least possible for the children's rooms, which should also be nice and bright on gloomy winter days.
Can something still be changed regarding the number or size of a light shaft? Bedroom in the basement (maybe you should rather call it basement instead of cellar) has advantages. Ultimately, it depends on what kind of people you are, but I would especially value the privacy and possibly the retreat room in the basement, especially with three children. In addition, the basement is also enlivened by this. Unlived-in rooms or floors, ypg once aptly called them "ghost rooms," I find unpleasant. If a room in the basement is regularly used, that radiates to the other rooms in the basement as well.
The no-go in my opinion consists in the loveless planning - ...
Could you please explain what you think the lovelessness consists of?
But (spontaneous visitors) guests should still be led to the sofa for a drink and then see the chaos in the kitchen...
I am a fan of closed kitchens and do not want to question your related decision. To relieve you a bit, I want to mention that with 3!!! children, one never has to apologize for any kind of mess, no matter where it is, nor will it bother anyone. That is the privilege of living with children. :)
You could still consider whether you want the open kitchen because it suits your wishes or has been fashionable for a few years.