You can try use Breeze, I have the same issue but I updated Breeze and suddenly I had cheats for Mario Galaxy. AIO did not find any cheats for this game.
The only way to fix the drift is to remove the old analog stick and install a hall switch one. Beware of the cheap ones on Aliexpress I had some of them that worked only for a while before they broke.