It works fine on non-SDrive sites – just put it in an iframe with the HTML tool.
What's really nice about it is you can add photos to the SDrive album (very easy) and see the instantly updated version on your webpage – no need to edit anything on your actual site, and no JS/JQuery to mess with either

Another method is just to link your own photo page/gallery to your site. Make it open in a new window though so people don't lose your site.