Not quite. As long as multiple programs use the same lib version, you only install it once just as with RPM or DEB.
but if another program needs a older or newer version you can install that version in parallel without it disturbing the rest.
but if another program needs a older or newer version you can install that version in parallel without it disturbing the rest.
And I don't see either what prevents one to distribute an application as standalone by stuffing all the libs needed in the application directory.