The declaration in your footer tells WordPress to find the sidebar-social_media_sidebar_widgets.php
file and apply it there.
I think what you want is to declare:
<?php dynamic_sidebar( 'social_media_sidebar_widgets' ); ?>
in your footer.php
file.