Hey Guys,
On my side, I just wanted to get rid of any clear mention of my password, either on a secret file or inside the docker compose file. What I did is just remove the WEBPASSWORD from the compose.
Then I logged into the container environment by typing:
docker exec -it <yourpiholecontainer> bash
and just run the pihole -a -p command to reset my password.
Hope this helps.