No. You do not need to subscribe to an Roland Cloud Membership to use additional tones on your Aerophone Brisa.
To access the additional tones, log in to the dedicated app "Aerophone Brisa Plus" with your Roland Account. For more information, please see the related Q&A "Can I add tones?".