Okay figured it out. Thanks for your help. It was a copy paste error in the secret itself. Had to change data to stringData:
apiVersion: v1
kind: Secret
metadata:
name: pihole-webpassword
namespace: mypiholesnamespace
type: Opaque
stringData:
password: [SNIP]