While the dearth of life skills is the proverbial Elephant in the Room for the millennials (born 1981-2001), the article itself isn't much better then clickbait. There's no link to the survey, or anything representing a complete list of the questions.
As for the Sheepshank knot. That's an odd knot to test on. I've never actually used it, preferring the dog shank (pouch knot) or alpine butterfly loop. You'd be better served by testing the workhorse knots (clove hitch, square knot, figure 8 family, etc)
****************
This is the gist of my concern in labeling CelNav "a backup for when everything has gone to heck". That may be true, as long as "everything" does not include a good time standard to reset your watch to. CelNav would be good for a while, but you would eventually need a known time standard, or a known location to reset your watch from. You would also need an almanac that contains data for a very long time. Or be a math whiz in spherical trigonometry (which most people have never even heard of) to calculate everything from scratch. The current "Long Term Almanac" goes to year 2050.
The time standard would be a concern for a full TEOTWAWKI/PAW scenario. For that, you would need a sundial or some other pre-tech time keeping device to certify to, and the aforementioned math wiz (recall that the first celestial navigation tables were published in 1767, so it's far from impossible to work out the tables by hand).
But, for the general "Where the bleep am I" situation, it's not a bad skill to have. A relatively accurate watch, compass (you should have these when traveling anyway), star chart ($25), and inclinometer will let you know which direction to start rowing