No. Transferring your domain only moves your domain hosting and related DNS settings to Squarespace. Your site content stays hosted with your website provider.
If you’re moving your current website to Squarespace, review Moving an existing site to Squarespace before transferring your domain.