Sips command shows 'not a valid file' warning

Another approach using Awk for post processing:

find . -iname '*.jpg' -exec sips -g pixelHeight -g pixelWidth {} \; | awk -F "[:/]" '$0 ~ /\./ {print $NF}; $2 ~ /[0-9]/ {print $NF | "tr -d \" \""}'

That yields this output format:

IMG_9088.jpg
3024
4032
IMG_9062.JPG
800
600
IMG_9076.jpg
3024
4032

The key here is knowing tha that you can use multiple field separators "[:/]" to your advantage to get the last field (NF) for each find output line category.

Tested: macOS Tahoe 26.1 and BSD awk, not GNU awk.

The preceding can be further refined with the same output result:

find . -iname '*.jpg' -exec sips -g pixelHeight -g pixelWidth {} \; | awk -F "[:/]" '$0 ~ /\.|[0-9]/ {print $NF | "tr -d \" \""}'

If you are seeking the folllowing output where the filename is contrived here for alignment purposes:

imagename1.jpg pixelHeight 3024 pixelWidth 4032
imagename2.jpg pixelHeight  800 pixelWidth  600

You could use this variation of the Find command:

find . -iname '*.jpg' -exec sips -g pixelHeight -g pixelWidth {} \; | egrep -o '([[:alnum:][:punct:]]+)' | sed 's|.*/||;s|:||' | xargs -n5 | sort -n

That will produce the following output format ascending by image name: