ERR: Improve error message for Series.loc.getitem with too many dimensions
- [x] closes #35349
- [x] tests added / passed
- [x] Ensure all linting tests pass, see [here](https://pandas.pydata.org/pandas-docs/dev/development/contributing.html#code-standards) for how to run them
- [x] whatsnew entry

tuple in tuple means we are indexing index and columns 
Good point. This is pretty straight forward thanks @phofl  @phofl I think this introduces a problem if the MultiIndex has a level that includes tuples e.g. (xref #27591)

```
lev1 = ["a", "b", "c"]
lev2 = [(0, 1), (1, 0)]
lev3 = [0, 1]
cols = pd.MultiIndex.from_product([lev1, lev2, lev3], names=["x", "y", "z"])
df = pd.DataFrame(index=range(5), columns=cols)
[test for DataFrame behavior (also broken xref #27591)

ser = df.iloc[0]
result2 = ser.loc[lev1[0], lev2[0], lev3[0]]  # <-- raises incorrectly
expected2 = ser.iloc[:1]  # actually i think this should drop all the levels and return a scalar, but thats a whole other thing
tm.assert_series_equal(result2, expected2)
```