The 2nd cable you listed is an SS1, not an SS2. It doesn't have a hole for the center pin to go in. Other than that, your idea is sound. This one should work: https://www.amazon.com/dp/B07S3XGZ61
SS2-50 connectors are designed for marine/dock power, and should be fine for weather use, but I wouldn't recommend immersion.