I did this many, many times during my struggles with non-24 sleep disorder. I would repeatedly stay up all night in the hopes that I would be tired enough to go to sleep at a reasonable time the next day.

Typically, one of two things would happen: either I successfully go to sleep at a somewhat early hour and then sleep for a few hours before waking up in the middle of the night unable to sleep, or I would feel tired in the early evening but try to hold on until I get to a normal bedtime and by that point I was no longer tired and I'd stay up late again even after being awake well over 24 hours.

Ultimately, my solution was to work on my own projects for a year or so (not something most people can afford to do). I ignored all requirements around sleeping and just slept when my body told me to. I kept windows uncovered and gradually, the sunlight started waking me up at a proper morning hour. For the first time in my adult life, I have a normal sleeping schedule and confidence I can be at my job on time. YMMV, but getting natural sunlight at the same time each day is huge as a circadian rhythm reset.