SSMS isn't based upon VS 2022 and therefore remains 32-bit. The SQL team doesn't actually manage the shell that they use, that is the VS team. The VS team ran into lots of challenges converting to 64-bit and broke all existing extensions in the process. To migrate SSMS to a 64-shell would require:
- The VS team to produce the 64-shell. As of yet I haven't heard they have done that.
- SSMS to update all its extensions to 64-bit.
- Any extension provider to update to 64-bit.
The work in VS 2022 is still ongoing in terms of getting everything updated so I believe it is premature to assume SSMS would be updated quickly. More importantly they are probably debating whether they even want to. Azure Data Studio has been sort of a parallel product that consumes more and more of SSMS features and is already 64-bit. The argument can be made that ADS would be the way forward here. Honestly I expect SSMS to go away at some point when ADS catches up to it in features.