Revise warnings to avoid changes in behaviors

[davide-f]

Checklist

• [x] I am using the current main branch or the latest release. Please indicate.
• [x] I am running on an up-to-date pypsa-earth environment. Update via conda env update -f envs/environment.yaml.

Describe the Bug

Please provide a description of what the bug is and add a minimal example/command for reproducing the bug.

Error Message

If applicable, paste any terminal output to help illustrating your problem. In some cases it may also be useful to share your list of installed packages: conda list.

<paste here>

[ekatef]

I think, the recent pandas deprecation fix #1023 could have resolved this issue. Do we have anything else to address here? :)