Kind of, but not really? At its core this article is basically a hack to do a bit of SIMD on an instruction set that doesn't have SIMD. Obviously SIMD is still highly beneficial on modern CPUs otherwise compilers would stop emitting it.

Eh, you can always move the performance frontier into something else, and the SIMD capabilities give you lots of strangely shaped instructions to play with. We have absolutely not seen the end of clever hand written code, it's just very rare.

Those specific tricks are irrelevant mostly due to compiler optimisations, even in compute heavy workloads.