>>23224750The purpose of this scene is to humanize Marika and show that she wasn't always a villain. The area is hidden away in a location where the casual player won't find it; only where someone who is actively trying to find secrets and the truth would go.
Four sentences of lore, an empty village, and a leitmotif from the main menu is all that was needed to convey that despite being a genocidal monster, Marika was once just a young girl from the countryside. Her entire life was destroyed when the Hornsent massacred her people and everyone she ever cared about. The brutality of the world changed her, and in an attempt to run from her trauma, she spent the rest of her life pursuing her dream of a world without death, all so should would never have to lose anyone ever again.
Upon achieving the supremacy of the Golden Order, she realized that she was now also a slave to the Greater Will, but she was willing to put up with it because at least she got what she wanted... until the Night of Black Knives.
When Godwyn plus the other demigods died, not only did she have the religious crisis of realizing that her Deity had fooled her, but she also had a relapse and had to basically go through the massacre of her people all over again. This is what caused her to snap, and to shatter the Elden Ring.
The Shaman Village provides context to the entire plot of the game.
Unless, your question about "what's the point to all this" was referring to irl
In which case, just to suffer