Son did a different tournament in Myrtle Beach (did the Ripken one in Maryland, and highly recommend).
We stayed with another family in a condo at Barefoot Landing in North MB, which is not ocean front. There are many. I actually found a mis-print deal for $79/night for a 4 bedroom on a third party travel site.
There is so much to do besides going to the beach. Many people vacation there. The year we took our boys for a week for vacation, we stayed in a condo, oceanfront, and went to the beach 3 times. There are minimal waves....MB doesn't have the undertow that the VA and NC beaches have.
I would think you would get a better deal away from the oceanfront.