If you look at moons as a way to advance in the game then - yes - there are way too many and the requirements are pitiful enough they lack any "objective" value. Of course, that comes with the caveat you're a seasoned gamer that wants to be challenged to progress. If, however, you're new to games, or a child, or physically limited etc., the abundance of moons allows you to make progress without frustration and feel a sense of accomplishment you might otherwise not get. In this respect, the abundant supply of moons is a brilliant design decision because it lowers the bar of entry for those who might typically be disuaded from playing games.
But what about those that do require a challenge? Well, some moons are gated behind platforming, some behind secret areas, and some are just plain obscure (you know the ones I'm talking about...). And while - yes - they may not be necessary to progress to the next level and complete the game, when has racing through a Mario game to completion on first play through ever been part of the draw? Rather, the value of these moons resides in the journey to acquire them. Perhaps you've spotted something a miss, or know there's one here somewhere marked with an x (thanks Toad) but I'll be damned if it actually exists!!! (you know the ones I'm talking about...). It is, after all, Super Mario Odyssey. Not, Super Mario Save the Princess goodbye.
I would even go so far as to say the example given in the video is a poor one. There is something beautifully intuitive about see rock - kick rock, and you're rewarded with a satisfying clink of a coin and deep rumble in the controller. 1 coin is fuck all, but I'm going to kick those rocks because it's titilating. But what's this, a rock that doesn't break? Kick, Kick, Kick - Moon! And thus I surrender my preconceptions and investigate everything, however mundane, because there are moons to be found in the most inconspicuous of places and I'm an explorer and will find them all, even the ones that are miles away (you know the ones I'm talking about....)
TL:DR Something something it's about the journey and not the destination. Nintendo should be applauded for creating a game that sets the bar low enough for neophytes, and rewards more experienced players with the many many joys of the game itself, not some arbitrary goal.