Enable more DPP Spark SQL tests

[andygrove]

What is the problem the feature request solves?

The follow Spark SQL tests should now pass because we fall back to Spark for DPP, so we should stop ignoring them. If they still fail then we should file a specific issue with the root cause and link to that.

sql/core/src/test/scala/org/apache/spark/sql/InjectRuntimeFilterSuite.scala:    IgnoreComet("TODO: Support SubqueryBroadcastExec in Comet: #242")) {
sql/core/src/test/scala/org/apache/spark/sql/InjectRuntimeFilterSuite.scala:    IgnoreComet("TODO: Support SubqueryBroadcastExec in Comet: #242")) {
sql/core/src/test/scala/org/apache/spark/sql/execution/RemoveRedundantProjectsSuite.scala:    IgnoreComet("TODO: Support SubqueryBroadcastExec in Comet: #242")) {

Describe the potential solution

Follow the instructions at https://datafusion.apache.org/comet/contributor-guide/spark-sql-tests.html to update the diffs.

Additional context

No response