(reposting my earlier comment, might’ve deleted it with a misclick)
Do you have any blocked numbers? Other users are reporting a weird interaction between blocked numbers and messages not appearing in the SMS app: