roachprod: http commands (eg, pprof) are broken

There are a few roachprod commands that attempt to make HTTP requests to the cluster. These weren't updated to appropriately handle the server's TLS certificate or to populate an appropriate JWT authentication cookie.

For example
```
roachprod pprof
```
fails silently when initiating the TLS connection.

Additionally, the command to begin collection of a storage compaction workload fails similarly:

```
roachprod storage collection start "jackson-collect-kv4kb:3" --volume-size 500
```

Jira issue: CRDB-51132