The president spoke of Emanuel AME church's historical role in defending the rights of African Americans in the Charleston community