There is no doubt in my mind and in the mind of most people that next World Cups will be likely more liberal and open the the behavior of those who decide to attend and have fun.
It is rather a cultural and political debate than something about the sport itself, I think. When we go to a muslin country, which follows the Sharia law, we are expected to respect and follow their rules, otherwise we can get severely punished. On the other hand, those who want to live under the sharia law in the west are free to do so, as long as they do not impose their beliefs onto others against their will.
Those are completely different systems.
After what I see in Qatar, I would be quite pessimistic if any other world cup was to be held in a Sharia/muslin country again, no fun allowed?
Well, after Australia opted out for the World Cup 2034 bid, Saudi Arabia is the only country in the race at the moment, so they will probably be hosting it.
So, yes, there will most probably be another World Cup host with Sharia Law.