I agree with you. I regularly have strong insomnia and I have tried physical exhaustion.

It usually works for the first few days of doing it but then it's like my body (probably moreso my mind) gets used to it and it doesn't help with sleep anymore.

Arguably it feels even more unhealthy because it's like my body is fully exhausted and tired but my mind won't let me sleep so no restoration can happen.