Improved Cone Search time-out error message

As discussed in #2687 .

Also updated an unrelated test because it looks like STScI VAO pruned some services off their registry. This has no impact on the `astropy` side of things, so I didn't bother to mention it in change log.