If you're doing production work then sure, you will need that kind of optimization to stay in business.
But if instead you are looking to produce one-offs with relatively low skill and a limited amount of money to spend on tooling then I totally see the point in making things from re-usable and easy to size components.
And then there is the garbage disposal element: almost none of this is waste, even at the end of life of the original object. The same goes for Lego, all it is is parts, and parts have a life of their own (in the decades!) that is totally different from the life of the objects made from them (minutes to several years).
So the over-design and the over-thinking go towards doing that work once so that the users of the system won't need a tools budget in the 10's of thousands of dollars (welder, plasmacutter, grinder, machine shop to go with it) and still build functional equipment that is not readily available.
As for how sturdy the bed frame looks: that's mostly a function of the design of the frame, not of the parts that went into it (Ikea sells kids bedframes that look quite close to what is shown in the article), you could do a much better job if you wanted to with the same parts.
I also note a lot of 'cheating' where the system doesn't work anymore (for instance: the stays to stabilize the bed and the legs under the sled).