SPACs and green companies were two of the hottest pandemic investments. Combining the two—green SPACs—has been even more profitable, but there is evidence this is changing.