Why Adobe Disabled the JavaScript Submit button When Secure a document with password ?

There are a couple of different ways to approach a solution. One method is to have the users manually save the form and email it back to you. This works on most platforms, even on mobile.  It works because Acrobat Reader can save a filled form, and its the user's problem to get it in the email.

The other method is to submit to a server, which requires something on the server end to catch the data. There are ways to write a simple server script that converts the form data into an email attachment and send it to you. I like this one for small setups because you don't have to muck around with managing data on the server.  But it's also outside the scope of this forum.

There are also services such as Form Router that do all the backend stuff for you.

You can also submit directly to google sheets, but this is tricky to setup.  The idea is to create a google form connected to a sheet, then name all your form fields for fields in the google form. Basically trick google into thinking its' the gform that's doing the submit

A better way to connect to google sheets is to write a google app to do it. This is something I've been meaning to do, but I'll get to some time

Data handling can be a pain because it requires some kind of external entity to handle the data transfer. You either have to spend some time working on it or pay someone else.