You don't attach the Sony account to your Steam account, no.

You login to your mog station account, and insert the game code for the PS5 version of the game. The game code should have been emailed to you when you bought the PS5 version.