I ended up commenting out the 'deb' line in the opera-stable.list file and left it coexisting with the opera-stable.sources I created.
jepjepus@debian:/etc/apt/sources.list.d$ cat opera-stable.list
# This file makes sure that Opera Browser is kept up-to-date
# as part of regular system upgrades
#deb https://deb.opera.com/opera-stable/ stable non-free #Opera Browser (final releases)
jepjepus@debian:/etc/apt/sources.list.d$ cat opera-stable.sources
Types: deb
URIs: https://deb.opera.com/opera-stable/
Suites: stable
Components: non-free
Signed-By: /usr/share/keyrings/opera.gpg
Other browser's developers team already solved this issue.
Regards,
Josep