Okay, two things. First, you need to echo out the statement. Second, you need to supply the user’s id. I usually place the current user ID in a variable I call $memberID.
<?php echo bp_core_get_username( bp_the_site_member_user_id($memberID) ); ?>
Try that out and let me know how it goes!