I am a fan of SpaceX, but I doubt we'll see another test in 2023, and at their pace they are ~5-10 "tests" from having a usable rocket. Starship is still 5+ years away.
I think it will mostly depend on the FAA. It seems SpaceX is still hoping another launch in the coming months.
And I'm hoping to ship my product in a month, even though we've already put in half a year and have loosely connected backend, frontend, servers and clients, most of which are barely a prototype.
Guess it depends on how you see things. I'd say it was up to SpaceX and they fucked up so badly that yeah, now they're gonna have to wait a long time to do another test, if FAA properly do their job and require more from them.
The failure of the flight safety system is a major screwup. I wouldn't want to be the person who has to talk to the FAA about it. Personally I'm not holding my breath for the next attempt.
How? They clearly have no launch pad system that can survive the back-blast. Unless they just trash another launch pad risking another rocket to debris damage.
I think everyone is still going to push for it to happen for the Artemis program