This is still relevant. And should be even easier to implement now that the terminus already supports falling back to another URL if the first one fails.
I would very much like to see this feature happening. My use-case is that I'm running Puppet in docker and having SRV support for PuppetDB would make auto-discovery very easy.