Clean walnode after drop database when using simple consensus

[HTHou]

Description

As title. The previous PR https://github.com/apache/iotdb/pull/13864 doesn't clean wal node when drop database.

[codecov[bot]]

Codecov Report

Attention: Patch coverage is 63.15789% with 7 lines in your changes missing coverage. Please review.

Project coverage is 39.85%. Comparing base (ce53f9c) to head (3fde3af). Report is 3 commits behind head on master.

Files with missing lines	Patch %	Lines
...db/db/storageengine/dataregion/wal/WALManager.java	0.00%	5 Missing :warning:
...g/apache/iotdb/db/storageengine/StorageEngine.java	0.00%	2 Missing :warning:

Additional details and impacted files

@@             Coverage Diff              @@
##             master   #13877      +/-   ##
============================================
+ Coverage     39.83%   39.85%   +0.01%     
  Complexity       71       71              
============================================
  Files          4153     4153              
  Lines        262894   262916      +22     
  Branches      32013    32018       +5     
============================================
+ Hits         104725   104779      +54     
+ Misses       158169   158137      -32     

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[sonarqubecloud[bot]]

Quality Gate passed

Issues
2 New issues
0 Accepted issues

Measures
0 Security Hotspots
0.0% Coverage on New Code
0.0% Duplication on New Code

See analysis details on SonarCloud