Disclaimer 1: I am not a professional photographer in case that's important to you.
Disclaimer 2: I don't really know what qualifies a photo as "tack sharp" or not. This seems very vaguely defined to me.
I know you've come here with some relatively specific questions, so I will probably disappoint you with my answer. One of the things that I hate about this site is that it seems to attract people who are fixated on what I would consider the minutiae of photo "execution". Yes, exposure is important. Yes, achieving focus is important. Pixel-peeping images at 100%? Why on earth does anyone do this? It's just a side-effect of digital photography – people do it just because they can. We all sometimes need to take a step back (literally and figuratively) and remember what photography is really about. That's also subjective from person to person, but for me, the essence of photography is about telling stories. We've all heard the expression "a picture paints a thousand words".
Every year, the "World Press Photo" jury in the Netherlands selects what they deem to be the best photojournalism from the previous year. There are categories including sports and nature, as well as general news. Some selections are individual photos, some are photo-sets. There's usually a touring exhibition, and it's invariably superb in my opinion. I highly recommend it to anyone, if you can get to one of the venues.
Now I know we are not all taking photos in such hurried/hazardous conditions, but I'd still like to use this as an example. Take a look at the overall winning photo from 2016, by Warren Richardson, titled "Hope for a New Life":
https://www.worldpressphoto.org/collection/photo-contest/2016/warren-richardson/1
A baby is handed through a hole in a razor wire barrier, to a Syrian
refugee who has already managed to cross the border from Serbia into
Hungary, near Röszke.
Is this photo sharp? Of course not. Does it work well, to communicate something to the viewer? Absolutely.
Take a look at more of the photos from the World Press Photo archive, and notice how many are just not sharp. (Viewer discretion advised – some of these photos depict some pretty dreadful situations.)
Now I'm not saying that we shouldn't take any care about our gear or our technique. All I'm saying is not to get absolutely fixated on it. Remember the reason you are taking photos.
Many years ago I took a trip to south-east Asia. I had a relatively cheapo lens mounted on a very-budget-SLR. But some of the photos I took there are some of my best, some of the photos I'm happiest with. Do I ever look at them and wish they were sharper? Not really. Of course I took plenty that didn't turn out as well as I hoped, but it wasn't the case that simply a "sharper" lens or higher resolution sensor would have fixed everything.

There's an apocryphal quote attributed to Henri Cartier-Bresson, that "sharpness is a bourgeois concept." I don't know if he really said exactly that, and I don't really think it even makes sense! But I think one thing is for sure – we need to focus on the images, not the pixels.