CATL already put sodium ion in cheap cars. And there are other benefits to this type of battery like a wider range of operating temperatures that cover essentially all of the extreme temperatures you'd find in the arctic and the hottest deserts.
I would not be surprised to find some of these batteries in big semis a few years down the line when the cost benefits make the space/weight sacrifices worth the trade off.
But you are right that domestic and grid storage are also going to be huge use cases.
Because they lose neither capacity nor charging speed at low temperatures, like the lithium-ion batteries, they expect that in the future sodium-batteries will be the best choice in the countries with cold climates.