higher sample rates can be very relevant for you. And audibly superior.
Yes, but here's the little flaw in my example with a sports playing field.
In sports, most attention will be on what's going on near the goal, right at the end of the playing field.
Our ears though are way more interested in the "midfield" action.
So it's typically not as dramatically "bad" and often not even audible in a negative way in a full music mix.
It's very easy to make these terrible effects audible by using e.g. pure sine sweeps through a distortion (saturation) stage.
But these are "lab conditions", not real world music.
People with trained ears can hear the difference when they can compare.
Is it even possible to produce good music in a digital environment without heavy oversampling in each plugin used? Yes, of course. Just like it was possible to create good music back in the day of vinyl when there were (are) physical limitations to e.g. bass response and bass transients.