That may work for you. I just tried it, and I can round my lower back while keeping my neck straight, and I can straighten my lower back while bending my neck.
I’m speaking from a dance background here, not a physical therapy/scientific background (so it might be a little different) but we’d distinguish between two different kinds of bending-over—one where we’d round the back, and one where we’d flatten the back.
When you bend over with a flat back, the only point of (apparent) movement (ideally) is at the crease of your hips. If you look at this dancer’s position, you’ll notice that if you turned the photo 90 degrees counter clockwise, and looked at her only from the hips up, you would be able to think she was just standing normally with her arms raised over her head (more or less). You couldn’t do the same in this image. I mean, it’s stylized, but look at the difference in the back alignment.
For another comparison, here’s an image with one person in multiple poses. Notice how the position of her upper body in A is almost identical to her upper body in C. Notice how in B, to bend farther over, she stopped tilting forward at her hips, and started instead to curve out the spine. Keeping the back flat requires more flexibility—as you tip your pelvis, you will feel a stretch in your hamstrings. (This is an important clue in why a hinge is important).
The trick to hinging is that it’s a quite active process. Your core needs to be engaged. Your upper back muscles need to be engaged. Your glutes need to be engaged. Your hamstrings need to be engaged. If you don’t engage all these larger muscle groups so that they can take and distribute the load, you can (and will) still damage your lower back—because its much smaller muscles will be taking all of that weight in a strained position. Although I stressed above how it looks like someone’s simply folding at a hinge point, there’s a lot of musculature involved in the movement.
The key: when you tip the pelvis rather than curving the spine, you’re allowing yourself to recruit your glutes and hamstrings in the movement (for the same reason that you feel a stretch in the hamstrings when you tip your pelvis—that’s where those muscles attach, that’s where they can pull). And recruiting the core and upper back muscles further distributes the weight across the upper body to protect the lower spine.
When you’re hinging for functionality rather than aesthetics, your knees should be slightly bent rather than locked, and you obviously won’t simply bend over to 90 degrees with straight legs—that’s not a position to pick up weight from; I just used that dance movement as a way to show the pelvis position. The farther the flat back is taken, the more difficult it becomes to properly recruit the other muscles needed to take strain off the back.
I think the author is going a bit extreme to be so opposed to the lower spine ever curving at all—I mean, that’s part of the vertebrae’s natural range of motion. The vertebrae aren’t fused together or anything… You just want to make sure you’re not asking the lower back muscles to take too much weight, and you want to make sure you carry yourself with your muscles rather than crunching into your skeleton. I do agree that using small moments like bending over the sink can be a useful way to practice and develop the muscle memory. (But like I said, I’m also coming from a dance perspective, not a scientific one).
Edit to add: I hope I addressed what you were wondering about?