Rooms with "space members" access are not listed in the space

### Description

Rooms created with access set to "space members" are not listed in "Rooms and spaces" of the space. There appears to be no way to discover such rooms unless directly invited to them.

### Steps to reproduce

Using the Element client:

- Create a private space "Space 1"
- Create a room in Space 1 called "Room 1" and select "Visible to space members"
- Click on Space 1

Expected behavior: Room 1 is visible in the "Rooms and spaces" list of Space 1 to anyone who has joined Space 1

Actual behavior: Room 1 is not listed in "Rooms and spaces" under Space 1

The same behavior occurs in Cinny and Fluffy.chat as well.

### Homeserver

matrix.org

### Synapse Version

1.147.0

### Installation Method

I don't know

### Database

unknown

### Workers

I don't know

### Platform

I'm able to reproduce this on matrix.org

### Configuration

_No response_

### Relevant log output

```shell
I do not have access to matrix.org logs
```

### Anything else that would be useful to know?

_No response_