How to find the password to my iPad's currently-connected Wi-Fi network?
If you're using iCloud Keychain, the password is synced to your keychain on your Mac and is therefore accessible in Keychain Access.

Open Keychain Access, select the keychain and look for the Wi-Fi network. Clicking show password will prompt for your password, then the network password will be displayed.