It is not an absolute truth that “the wave function collapses”. That is just one possible interpretation. Albeit a popular one.
It is true that the “problem of measurement” has occupied the great minds of quantum mechanics. Here is a somewhat more rigorous explanation.
Alas, the great minds have also made mistakes on occasion. Also, it seems they can be prone to “stuck paradigms”.
QM says that you need to perform a measurement (open the box) in order to observe a value (whether the cat is alive). The traditional interpretation says that until you perform a measurement, the value “isn’t decided yet”. It’s not that you merely don’t know whether or not the cat is dead - tradition says that the cat is both dead and alive, awaiting the final decision which happens the instant you look.
It goes further. Tradition says that if you think the cat is either definitely dead or definitely alive before you look, you are factually wrong. You can actually perform an experiment that proves that idea wrong. You can do an experiment that proves the cat cannot be either definitely alive or definitely dead. (This is extremely paraphrased; I am deliberately confounding this with a different phenomenon, for the sake of explanation.)
However, the traditional interpretation of QM is not the only correct one.
A different interpretation of quantum mechanics exists that is entirely consistent with the fundamental formulas of QM. This interpretation does not entail “collapse” of the wave function. It does say that observations have definite values all the time. The cat starts out alive, and if the radioactive decay occurs at some point, it kills the the cat.
This alternative interpretation makes QM entirely deterministic and objective. It also neatly removes the problem of measurement. It is called Bohmian Mechanics, or Bohm’s interpretation.
Bohm’s formulas make the exact same predictions as fundamental QM. Predictions that have been thoroughly confirmed in actual experiments.
It is still true that some of the phenomena are “strange”. Bohm’s interpretation reflects that. (I.e. Contextuality and Nonlocality.) This is not a problem with Bohm’s interpretation. It is a “problem” with the Real World. Personally I have never had any trouble with this. We can do the experiments and observe the outcome right in front of our eyes. In fact, we observe the “strangeness” of QM all the time. Consider all the materials we have in the world - all the chemical reactions - all of that is deeply connected with Quantum Mechanics and its strange principles.
Here is a nice dissertation on the “paradoxes” of QM and the case for Bohm’s interpretation. It is heavy on the math but the abstract and summary might give good impressions.