Drush is not recognizing Acquia extension
Can you confirm that you can see your acquia site aliases?

drush sa


I haven't done anything beyond the suggested tar -C $HOME -xf $HOME/Downloads/acquiacloud.tar.gz and drush help --filter=acapi shows all the commands.