Add a JS app in Acquia root domain folder
is your frontend an Angular / React / Vue app?
Anyway I don't know Acquia cloud but I can confirm that your setup works on an Apache server. I have my Angular app in the root folder along with the vendor and and web folders, and then I have in the web folder the core, libraries, modules eccc.. folders.