That's not really useful and can be counterproductive.
When a shell reaches the end of its input, it exits already with the exit status of the last command that it ran. exit without a number also exits with the exit status of the last run command.
If you add that exit, then that script can't be sourced any longer as exit would exit the shell that sources your script.
Or it would prevent bash from interpreting another-script in:
cat that-script another-script | bash
IIRC, there used to be some old versions of some shells where the EXIT trap would only be run upon an actual exit call, so using exit could have been useful there.
Using exit could be useful in some use cases where you want to be able to instrument your script for a reason or another. In POSIX sh implementations, exit can't be redefined as a function as it's a special builtin. It can be redefined as an alias though. In bash, unless in POSIX mode, alias expansion is not performed in non-interactive invocations (such as in scripts) unless turned on explicitly, but, if POSIX mode is not enabled, it will let you redefine exit as a function, and even inherit an exit function from the environment.
So for instance, running your script as:
env 'BASH_FUNC_exit%%=() {
echo>&2 "Exiting now."
builtin exit "$@"
}' ./your-script
Would output Exiting now. upon any exit, including the one added at the end.
Using exit can be useful when written:
#! /bin/bash -
{
# contents of the script here
...
exit
}
That kind of trick is useful when you want to guard against the script being overwritten whilst it's being run. Here, bash needs to read the script up to the closing } (and store its interpreted code in memory) before doing anything, and because of that trailing exit, after it has done that, it will not read the script any more.
exitcan be used to ensure anything after that is not executed even if someone appends to the script file. Other structures can be used to make sure the shell reads the whole script file before doing anything, preventing modifications during the script execution from changing what the script does. But that's not worth too much security-wise, since of course any changes to the script file would take effect the next time its run.