> in The Netherlands it was €210 for a 40 minute ride
That's much more than taxis cost in the UK, and pretty expensive even for the Netherlands. You have great cycling infrastructure, and public transport though.
Renting a car is an affordable alternative to ownership, if you need to go to occasional concerts or birthday parties, and public transport happens to be inconvenient for your specific destination. I did that for years - the rental company would deliver and collect from my workplace, so it's super-easy.
> If your children play football you really need a car.
A friend of mine used to ferry his son 1000s of km per year to ice-hockey matches around the country, so I know what you mean. I don't understand it though - if the whole team is travelling, why don't they just rent a bus? Personally, I don't think it's healthy for a child's hobby to consume so much of the parents' time - of course, your choice.