TST update and simplify consortium api test
It's quite likely that the dataframe api will have a `Scalar` class, and that `Column.get_value` will return that

I'm suggesting to just simplify the test to make an assertion about `Column.name`, which realistically isn't going to change

---

Docs CI failure is unrelated and due to https://github.com/scipy/docs.scipy.org/issues/80
Thanks @MarcoGorelli  @meeseeksdev backport to 2.1.x