I couldn't agree more. I don't think compiler vectorization is that useful even for columnar (!) database we're building. The specialized JIT doesn't even use AVX512 because too much effort for little to no gain.
Auto-vectorization can be fragile. Manual vectorization is a ton of work and difficult to maintain.