[eslint] Reenable no-floating-promise

[emaxx-google]

This plugin has been fixed upstream to be compatible with ESLint 9.0.

Hence we can partially revert #1144 to reenable it as part of our lint checks.

[github-actions[bot]]

Continuous Integration: All tests passed. C/C++ test coverage: 73.33% lines.