My kids don't play goalie for their teams ---now U14 and U17.
But--they love playing basement soccer and at the backyard net---and favorite thing 1v1 is being the goalie and diving on the ground and trying to make saves.
They both had a turn or 2 in goal on their U9/10 teams when every kid was required to play it at some point. They now both play center mid.
When they play Futsal they will sometimes volunteer to play goalie and I am amazed that they are actually pretty good at it--but I think it mirrors their basement soccer on are hard tile floors and close-up shots

.
I could never be the parent of a goalie. It seems very stressful. Also- they make a mistake and it costs a goal. A forward can make mistakes the entire game and no big deal. The goal has a fumble or comes out too far or misses a penalty shot and feels the loss heavier. I also didn't like when my kids played sweeper for a similar reason. They could play outstanding the entire game and 1 play someone would get by and then you had to hear all the idiots on the sidelines whose kids could never finish and missed opportunity after opportunity scream about the defense.