I think it’s fine.
I love gardening, but all we could afford was a house with a small courtyard garden. It’s got two brick raised beds, and I grow lots of things in those and pots - so still a great way of showing our DS how to grow your own fruit and veg.
There’s enough room to keep bikes and set up a tiny table for outdoor eating in summer- but that’s it. It’s a real shame, as DS is very active, and of course I’d love a big garden for him (and me!) - but this was all we could afford in the catchment area of the school we like the look of. We prioritised school catchment and proximity to a main line railway station.
We’re also near two playgrounds, a big park, a nature reserve, and can walk in to open countryside in ten minutes - so it’s not as if we’re cut off from loads of space nearby for bike rides and walks etc.
We take DS out twice a day to ensure he gets a good run around, and do lots of country walks etc. It is what it is; housing is expensive, and gardens in new homes are tiny. Increasingly, older houses with massive gardens get built on as soon as they’re sold nowadays too.
Yours looks fine, if it’s near a park I’d buy it - but my other priority would be quality of the nearby primary school. The years race by, and you’ll be applying before you know it.