Unfortunately, this is what happens in football. It's hard, because your local village team effectively isn't that any longer and by moving teams you're having to drive to training, drive to matches, so this impacts on the family as it takes up more time. There are also new people to meet, a new dynamic to understand and you need to throw the cosy slippers away.
I've had two DSs play football for a number of teams over the years. They've moved on from their original teams for many of the reasons mentioned - being dropped, or playing a minimal amount of time, getting cold on the bench and failing to perform when it's their turn for five minutes on the pitch, being poached by the coach of another team. They've done academy football and we've shelled out a lot of money.
Before you know it, it's not about "what can we (the coach, manager, club) do for you son", but rather ""what can your son do for us" and you're quickly dropped if the answer to that question is "not a lot".
As one DS is goalie, he gets to play 100% of every match. He makes great saves, and any goals he lets in are "defensive errors", never "goalie errors". Well, there might be one every once in a while and we then just chuckle in the car on the way home.