SLS never was going to enable space tourism. You have private companies doing that, and doing it better than Boeing.

SLS is worse than existing rockets in every way but one. Lift Capacity. Near term expected Space tourism doesnt need super heavy lift capacity. cheaper, faster, more reliable rockets already exist to get humans into LEO

While Falcon Heavy or Delta may be able to do some of the artemis missions, they currently cannot do all of them planned. Simply because of lift capacity or payload volume. However it will be interesting to see what happens to SLS if SpaceX gets starship going before SLS. Since SLS has already been in development for almost 10 years, and Boeing is in charge, many people think we will see an orbital Starship come to market before SLS hits orbit, and essentially rendering the entire SLS program a complete waste of time and money.

But dont worry, SLS will in no way slow down you getting to go to space, or your kids becoming belters. That timeline is independent of SLS, and may even be accelerated because of SLS failures.