Hi, As per the official documentation "the retention range for an on-demand backup is the retention value that you specify when you trigger the backup.". So, on-demand backup will be retained only for the specified period defined not according to policy.
Please "Accept the answer" if the information helped you. This will help us and others in the community as well.