No. The SP-404MK2 App can be used without subscribing to a paid Roland Cloud plan.
Create a Roland account and install Roland Cloud Manager. For details on installing the app, see "How do I find and install the SP-404MKII App?".
Note: Keep the SP-404MK2 system program, the SP-404MK2 App, and Roland Cloud Manager updated to the latest version for best compatibility.