What should I do for Allah to be pleased with me and forgive my sin after I drank alcohol and committed sins while I was drunk, and then repented?

You erred when you resorted to the path of deviation after the shock, and what was obligatory was to turn to Allah. The door of repentance is open no matter how great the sin, for Allah accepts repentance from His servants and forgives all sins. And whoever repents with sincere repentance, regretting the sin and resolving not to return to it, Allah erases the effect of that sin from him, for the one who repents from a sin is like one who has no sin. So, you must turn to Allah, strive in obeying Him, increase in good deeds, be keen on righteous companionship, and adhere to dhikr (remembrance of Allah) and dua (supplication).