What we can establish
The official FAQ confirms Steam carry-over. It does not establish cross-platform transfer to PS5 or Switch 2.
What to do next
If you plan to play on a console, treat the demo as a way to try the game rather than a guaranteed head start on that platform. Keep a backup of your companion notes separately.