Is Leafpool now just a regular warrior after 'Sunrise'?

We don't know for sure, but it is unlikly. They did find out about Leafpool's forbidden relationship with Crowfeather long before, but they did not know that they had kits. That was the only new information revealed and I don't think it would change Leafpool's position.