Why "yum update" fails with multiple conflict errors?

Issue

• The yum update command fails with multiple conflict errors, even though the DNF repositories are up-to-date, and no package-related issues are reported by the package-cleanup --problems and package-cleanup --dupes commands.

  Problem 1: package pcp-pmda-mongodb-5.3.7-22.el8_10.x86_64 from rhel-8-for-x86_64-appstream-rpms requires pcp-libs = 5.3.7-22.el8_10, but none of the providers can be installed
   Problem 2: package pcp-pmda-denki-5.3.7-22.el8_10.x86_64 from rhel-8-for-x86_64-appstream-rpms requires pcp-libs = 5.3.7-22.el8_10, but none of the providers can be installed
   Problem 3: package platform-python-pip-9.0.3-24.el8.noarch from rhel-8-for-x86_64-baseos-rpms requires platform-python >= 3.6.8-55, but none of the providers can be installed
   Problem 4: package python3-pip-wheel-9.0.3-24.el8.noarch from rhel-8-for-x86_64-baseos-rpms conflicts with platform-python < 3.6.8-55 provided by platform-python-3.6.8-51.el8.x86_64 from @System
   Problem 5: package gdk-pixbuf2-modules-2.36.12-5.el8.x86_64 from @System requires gdk-pixbuf2(x86-64) = 2.36.12-5.el8, but none of the providers can be installed
   Problem 6: cannot install both perl-libs-4:5.30.1-452.module+el8.4.0+8990+01326e37.x86_64 from rhel-8-for-x86_64-appstream-rpms and perl-libs-4:5.26.3-422.el8.x86_64 from @System
   Problem 7: cannot install both perl-libs-4:5.30.1-452.module+el8.4.0+8990+01326e37.x86_64 from rhel-8-for-x86_64-appstream-rpms and perl-libs-4:5.26.3-422.el8.x86_64 from @System
   Problem 8: cannot install both perl-libs-4:5.30.1-452.module+el8.4.0+8990+01326e37.x86_64 from rhel-8-for-x86_64-appstream-rpms and perl-libs-4:5.26.3-422.el8.x86_64 from @System
   Problem 9: package authselect-compat-1.2.6-1.el8.x86_64 from @System requires authselect(x86-64) = 1.2.6-1.el8, but none of the providers can be installed
   Problem 10: package bpftrace-0.16.0-1.el8.x86_64 from @System requires libclang.so.15()(64bit), but none of the providers can be installed
   Problem 11: package cups-ipptool-1:2.2.6-51.el8.x86_64 from @System requires cups-libs(x86-64) = 1:2.2.6-51.el8, but none of the providers can be installed
   Problem 12: package dbus-x11-1:1.12.8-24.el8.x86_64 from @System requires dbus-daemon = 1:1.12.8-24.el8, but none of the providers can be installed
   Problem 13: package elfutils-debuginfod-client-0.188-3.el8.x86_64 from @System requires elfutils-libelf(x86-64) = 0.188-3.el8, but none of the providers can be installed
   Problem 14: package elfutils-debuginfod-client-0.188-3.el8.x86_64 from @System requires elfutils-libs(x86-64) = 0.188-3.el8, but none of the providers can be installed