You should keep at least some small amount of page file on your system for a crash dump. How much depends on the setting for your system but chances are you as a home user it is set to "small" in which case it does not need to be a large page file at all.
From How to determine the appropriate page file size for 64-bit versions of Windows
System crash dump setting | Minimum page file size requirement
Small memory dump (256 KB) | 1 MB
Kernel memory dump | Depends on kernel virtual memory usage
Complete memory dump | 1 x RAM plus 257 MB*
Automatic memory dump | Depends on kernel virtual memory usage. For details, see Automatic memory dump.
Whether it is worth moving depends on the types of SSD. There would be little benefit in moving from an NVME SSD to a SATA SSD, due to SATA being slower, but the other direction could be worthwhile.
If they are both the same type then the benefit is going to be marginal and depend on how heavily one drive is used and the type of work you do. Large video editing with page file on the same drive might result in some bus contention in low memory situations, so you'd want the page file on to the other drive from that work.
Other than that there is little benefit to moving it. SSDs are much less prone to the problems of seek times that make hard drives painful to use when they are paging data in and out.