Ratings arent hard to find. 800,000 viewers for a cw show is fine and all but not a major number.
Compare that to stranger things or the rings of power had like 25 million viewers per episode.
Also Buffy and Power Rangers were Absolutely blockbuster shows for there demographics.... so im not sure why ur comparing cw to those shows.
Those shows had minimal competition when they were released. Many people had bunny ears and 5 channels when rangers dropped.
Cw in 2022 has literally thousands of shows to compete with.
If superman and lois were doing Stranger things type business then by all means it might make sense to use a tv Superman in a motion picture...
But as it stands objectively nobody watchs superman and lois.
We do have the numbers
Attachment 127348