HubSpot is a native/supported connector for AppFlow. I recommend attempting to troubleshoot directly with appflow support/documentation.
Please share error from Appflow for best support there please reach out to support.
If for any reason appflow wont get you the data you need there are various other options in the market that can assist with building data pipelines to hubspot and get your data in s3/redshift.
Thanks
Ramon