Why replacing /usr/bin/python3 broke apt on my Ubuntu system

The problem I installed Python 3.12 for a project and pointed /usr/bin/python3 to it, instead of using a virtual environment. Everything worked fine at first. A few days later, add-apt-repository fail