I do wonder if, with the modern day lenses ie mirrorless lenses that, if you put an image taken "sharp" - in the supposed sharp aperture range next to one more wide open, and asked those that live and die by the sharpness of the aperture premise to identify which is which, whether they actually could.
In short is there that much of a noticeable difference for everyday use.
A good question

Some people obsess about sharpness, they study lens data, MTF data, every other factor that could possible help them to rationalise their decision to spend a lot of money on lenses, and that's fair enough, it's a kind of sub-division of photography that matters to them, but most of us just take photos and judge them by different criteria, rightly or wrongly.
I've recently been going through pictures of local scenes taken over the last 11 years for a friend who wants some prints. Even viewing normally in lightroom I can see a progression in definition as the kit has got better, and some older shots benefitted cleaning up and detail enhancement from more recent software.
It's not about sharpness as such, but it is about clean undistorted rendering, especially in areas of high contrast.
Agreed. And sharpness isn't always objective anyway, a lot depends on the scene, for example a photo taken in mist/fog may be perfectly sharp but may not look sharp because of the very low subject contrast.
And then we find ourselves in the realm of viewing distance, where a photo looks sharp at the "correct" viewing distance but doesn't stand up to viewing at much closer distances.
DOF is another one, there can only ever be one plane of sharp focus, but DOF, increasing with smaller formats, smaller apertures and greater distances, is really nothing more than one plane that's actually in focus, with areas in front and behind that plane that
appear to be acceptably sharp, Manufacturers have always published DOF charts fro their lenses, many years ago there were "Russian" lenses (actually made in The Ukraine) that claimed to have greater DOF than the lenses from other countries, and a lot of photographers swore blind that they were better, but the reality was that they used different criteria (different size circle of confusion) to produce different data.
1. Camera/hand shake. When using longish zooms handheld, shake will happen randomly, regardless of how hard I try to hold steady. I use release setting 'continuous low rate' by default, which makes it easy to take single shots but holding the shutter release will keep it firing. I always take at least 3 frames, a few more if it's an important or unrepeatable shot. It's surprising how often there are only one or two properly sharp ones even when using VR/IS.
Some more very good points, but I'll just address the one I've snipped, above. That's you, and many other people, but personally I can hold a camera very steady. That sounds like a boast but it isn't, it's just a fact, which I put down to a lifetime of experience at shooting rifles, where any movement is amplified by magnification, just like photography. We're all different.
My overall advice? Don't obsess about it, or if you want a more eloquent summary (although I've never described
@Phil V as eloquent before

) read this again
My favourite quotes re ‘sharpness’ are:
Sharpness is a bourgeois concept
And
There’s nothing worse than a sharp image of a fuzzy concept
And neither of them make any sense to me; but then neither does the concept of ‘sharpness’.
If I need an aperture of f11 to create the image I want, then what’s the point in knowing that I’ve gone beyond the point of optimum sharpness and am heading towards diffraction?
Likewise if I need to use f2.8 to isolate my subject, what’s the point in knowing it’d be sharper at f5.6?
I feel like a broken record every time I say to a newbie ‘don’t lose sight of the fact that you started this to make pictures’.
It’s far too easy to get dragged into rabbit holes of ‘sharpness’, ‘noise free’ or simply obsessing over the maths of the exposure triangle.
If you’re not having fun trying to make pictures that make you feel something, then what’s the point.