they should have made this control elements and combine the over elemental cantrips

Wow, they MASSIVELY Nerfed all the Control Element spells. This cantrip is an utter waste of a spell. I'd rather buy four cantrip spells to get all 4 control elements and have them do their original function than 1 cantrip that does nothing in 4 elements.

Will this provide drinking water with Beckon Water? Or will it evaporate inside the body after drinking?

Eh...it's better than Druidcraft, but not as good as Shape Water.

Feels bit like thaumaturgy

Even with the big nerf, I appreciate not having to pick up 4 separate cantrips with massively varying power levels. If a single cantrip had the same combined power as shape water, mold earth, control flames, and gust it would probably be a bit much.

Um, aren't the control elements spells still there? They weren't in the 2014 PHB and if it wasn't revised, it's still in the game. It's disappointing that the sword cantrips weren't included, but those also were added later. Unless your DM refuses to allow you to learn them, they are still available. This cantrip was created for the Warrior of Elements Monk to replace their previous elemental attunement.

Evaporates after a minute, no condition if consumes, I'd say yeah. If they wanted it to last they would have said "unless consumed." Now, in a low resource survival situation,  I can see this as being useful (by recasting every 30 seconds or so). Also to dump over your head to cool off on a hot day. Actually, there are quite a few uses, now that I think about it: clean a wound before first aid, clear your throat while speaking, throw in a rival's face at a social event (or better yet, dowse their pants to look like they wet themselves), it's a cup of water that you create for a minute. Shame that it only temporarily slacks your thirst. 

Those cantrips are still there. They weren't in the 2014 PHB, so they weren't revised and thus still there in Xanthar's, I believe. Along with the sword cantrips. Unless your group is doing 5.24 PHB only, you can still grab them.

How many of y'all would let your players use sculpt element to create temporary nonmagical weapons put of fire or water or whatever?

There's no way that fits within the context of the description. It's essentially homebrewing at that point. 

Quote from DemHarp01 >>

How many of y'all would let your players use sculpt element to create temporary nonmagical weapons put of fire or water or whatever?

 The spell does what it says it does-nothing more and nothing less. As Ryuken says, you could homebrew a spell that does that, but I would think it would not be a cantrip. The Flame Blade spell does something similar to what you are describing, and it's a second level spell.

Chill, these are for flavor not power. It’s a default spell ability of the Elemental cultists, and they have use in adventure situations from creative and insightful players. The other damage related elemental cantrips are still available to choose from based on one’s campaign/world setting.  
Also, cantrip like these can be awarded to players as a boon for something they discovered or accomplished. 

Quote from Rexs424 >>

they should have made this control elements and combine the over elemental cantrips

 

 Probably because some of the elemental control cantrips are really powerful in the right hands, like Shape Water and Mold Earth.  Mold Earth allows you to dig tunnels and trenches more easily than digging with a shovel, and you can use the extra mounds of dirt you dug up to create makeshift cover for combat.  I used Mold Earth to get around a locked door in a subterrean dungeon by moving the stone around the place where the door meets the wall to free the lock.  It might even be possible to move around the stone around a stalactite to dislodge a stalactite from it's foundation and make it fall on an enemy (would deal 1d6 piercing damage per 10 feet it fell).  

You can even try to create a 5-foot deep hole underneath an enemy to hopefully trap them or at least slow them down (they will have to climb or jump out).  If you are in a house or building and the ceiling or walls is made of some type of stone-like material, you can move out one portion of a pillar or wall to cause the structure to collapse in on itself and possibly suffocate or crush enemies inside.

Finally, Summon Incense...