There’s no built in Weather app for the iPad. As you’ve noticed, you can add it to your Today view as a widget.
This:
View attachment 88938
You have to allow location access it in Privacy - Location Services - Weather, though, or else it won’t show anything.