Agreed. It's really not a panacea. When you upgrade a library, you probably want to restart the running applications that depend upon this. Dynamic linking won't save you.
The solution is having a graph of your dependencies! IIRC, NixOS gets this right. I don't think Debian's apt did?