Can a Mac enter sleep mode on schedule when a third party app tries to prevent sleep?

No. Power manager assertions can be artificially created (e.g., via caffeinate) but they can’t be removed except by the app itself. You can, at least, view the current assertions via

pmset -g assertions

and see what kind of assertion your app has taken.