The export can be also done through experimental /db endpoints in Admin API if you are looking for automation (note experimental would mean you’d need to keep an eye on any upcoming changes).
Most of the tables are needed but some are excluded for security reasons. In theory, if you are ok creating a dump of the whole database and are sure the data will be stored securely, then there’s no one to stop you 