Turbulent momentum transport in core tokamak plasmas and penetration of scrape-off layer flows